deleting muliple feilds from a table using an array
| From: | benifactor | Date: | Fri, 24 Mar 2006 21:09:02 +0000 |
| Subject: | deleting muliple feilds from a table using an array | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-232561@lists.php.net to get a copy of this message | ||
example code:
//implode the value of the submitted form
//$del will look like 38, 40, 43
$del = implode(",", $idd);
//create query for the deletion of values from submited form
$query = "delete From news where id = '$del'";
//execute query
mysql_query($query) or die(mysql_error());
//echo sucess message
echo("<b><center>The Post has been deleted...</b></center>");
here is what my problem is...
This code will only delete the first value of $idd. what i think is wrong is i have the incorrect
syntax to delete multiple feilds from a table if some one can help me it would be greatly
appreactiated.