Unlink - Need help

[bluemouse2]

Hi!
Can you please help me delete several files with unlink?
php Code:

 $sql = "select filename from $aaa where owner='$id'";
   $result = mysql_query($sql) or die("Failed: $sql");
   $resrow = mysql_fetch_row($result);
 $filename = $resrow[0];
 @unlink("./files/".$filename);

this code deletes only one file.
there are several files to delete.

where do i go wrong? thanks.

 

[Noobie]

 $sql = "select filename from $aaa where owner='$id'";
   $result = mysql_query($sql) or die("Failed: $sql");
  while ($row = mysql_fetch_array($result)) {
        @unlink("./files/".$row[0]);
}

Try this

 

[bluemouse2]

Thank you!

 

[Noobie]

no prob.
You can / should use mysql_fetch_row like you did in your code since your going to return an enumerated array

 

[Tree]

The @ opertor is extremely slow. It'd be best if you checked if the result file existed, and then unlinked it.

 

[Noobie]

its not extermely slow ... it's slower.