deleting records and files from mysql

[Anon]

Hello all,
Can anyone help me with the following code?

I have a field called picture_name in a table called cool.
I want to match a name is contained in an array with the name in the field and delete it.

Can anyone help? (apologies for the poor coding - I'm very new to this).

$chosen = "image26.jpg,image27.jpg,image28.jpg";
$remove = explode(",", $chosen);
$query = "DELETE FROM cool WHERE picture_name=$remove[$i]";
$i = "";
while ($i <= count($remove))
{
$result .= @($query);
$wipe .= unlink($remove[$i]);
print "$remove[$i]";
print "$i";
$i++;
}

mysql_close($link);

regards,

Sean Wood.

[flipis]

Using @ will supress all error messages, and maybe you don't want this to happen. Sometimes it is useful to get the error messages.

Explode creates an array beginning with 0. I'd rather use for, like:

for($i=0;$i<count($remove);$i++){
$result = mysql_query($query);
$wipe = unlink($remove[$i]);
print "$remove[$i]";
print "$i";
}

And don't use .= for the mysql_query or the unlink function. You dont wan't to add anything to the result of them. Else, $result will be "image26.jpg" at first and after it will be "image26.jpgimage27.jpg";

So, when trying to unlink the second, no result, not in unlinking or in mysql row deleting.

I never use unlink like you did here. I mean, you don't have to do

$wipe = unlink($image);

but

unlink($image);

and that's all

Hope it helps

fLIPIS