You can use the following code to delete multiple items:
if(isset($dele) && (count($dele) > 0)) {
$sql = "delete from gastenboek where (entryID='$dele[0]')";
for($i=1; $i<count($dele); $i++)
$sql .= " or (entryID='$dele[$i]')";
$res = mysql_query($sql, $connection);
}
Raul
----- Original Message -----
From: "Davy Obdam" <[EMAIL PROTECTED]>
To: "Php Mailinglist" <[EMAIL PROTECTED]>; "Php-Windows Mailing"
<[EMAIL PROTECTED]>
Sent: Monday, October 07, 2002 4:05 PM
Subject: [PHP] Deleting multiple items from database using checkboxes
> Hi people,.
>
> I have a guestbook admin page were i would like to delete one item or
> more items from the database if necessary. I have modified my normal
> guestbookpage so that it has checkboxes in front of every entry. This is
> my code:
>
> <input type=\"checkbox\" name=\"dele[]\" value=\"".$sql['entryID']."\">
>
> Now i can select multiple items. But i have tried to delete em, but it
> only deletes one item from the database, my query looks like this :
> DELETE FROM gastenboek WHERE entryID=$dele . Can anyone help me. Thanks
> for your time.
>
>
> Best regards,
>
> Davy Obdam,
> mailto:[EMAIL PROTECTED]
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
