sql - How to Unlink a File from Website's Folder when MSSQL Table Row is Deleted Using PHP -

i trying make link <a href='{$_server['php_self']}?del=true&orderid={$row['orderid']}' style='color:black;' onclick='return show_confirm();'>delete</a> delete specific row mssql table using while function. currently, bottom code works fine , deletes specific row table, unlink file sharedstorage folder. file gets unlinked has it's filename stored in name column table row. each table row has name column contains unique file's name file located in sharedstorage folder.

my problem in simple terms when table row gets deleted, file row in website's sharedstorage folder remains , not deleted row.

here code when delete link hit specific row:

// delete table     if ($_get['del'] == 'true') {        // cast id int security        $id = (int) $_get['orderid'];        // delete row table        $sql = "delete shareddrive orderid = '$id'";        $result = mssql_query($sql, $conn) or die(mssql_get_last_message());        // select info, ordering usort        $sql = "select orderid, name, type shareddrive order orderid";        $result = mssql_query($sql, $conn) or die(mssql_get_last_message());        // initialize counter rewriting usort        $job_pos_sortt = 1;        // while there info fetched...        while ($r = mssql_fetch_assoc($result)) {           $job_poss = $r['orderid'];           // update usort number 1 in next number           $sql = "update shareddrive set orderid = '$job_pos_sortt' name = '$job_poss'";           $update = mssql_query($sql, $conn) or die(mssql_get_last_message());           // inc next avail number           $job_pos_sortt++;        } // end while // end if del     } 

all appreciated.

// delete table     if ($_get['del'] == 'true') {        // cast id int security        $id = (int) $_get['orderid'];        // delete row table         $file = mssql_fetch_array(mssql_query("select name shareddrive orderid = $id"));        unlink($file[0]);              $sql = "delete shareddrive orderid = '$id'";        $result = mssql_query($sql, $conn) or die(mssql_get_last_message());        // select info, ordering usort        $sql = "select orderid, name, type shareddrive order orderid";        $result = mssql_query($sql, $conn) or die(mssql_get_last_message());        // initialize counter rewriting usort        $job_pos_sortt = 1;        // while there info fetched...        while ($r = mssql_fetch_assoc($result)) {           $job_poss = $r['orderid'];           // update usort number 1 in next number           $sql = "update shareddrive set orderid = '$job_pos_sortt' name = '$job_poss'";           $update = mssql_query($sql, $conn) or die(mssql_get_last_message());           // inc next avail number           $job_pos_sortt++;        } // end while // end if del     }