[SOLVED] unlink not working

[dennismonsewicz]

Code:

 

$query2 = mysql_query("SELECT * FROM uploads where id = " . $id . "");

							$row = mysql_fetch_array($query2);

							$filename = $row['name'];

							$imgdir = "imageuploads/";

							unlink($imgdir . $filename);

 

For some reason the above code does not work. Any ideas?

[GingerRobot]

For starters, add error checking on the query:

 

<?php
$sql = "SELECT * FROM uploads where id = $id";
$result = mysql_query() or die(mysql_error().'<br />On the query:'.$sql);
if(mysql_num_rows($result) == 1){
    $row = mysql_fetch_assoc($result);
    $filename = $row['name'];
    $imgdir = "imageuploads/";
    unlink($imgdir . $filename);
}else{
    echo 'ID does not exist!';
}

?>

 

 

[dennismonsewicz]

ok did that and still it is not deleting it out of the dir

[dennismonsewicz]

I fixed the problem