Wouldn't you want to do a foreach() loop?
i.e.
foreach($dele as $whatever) {
mysql_query(DELETE FROM gastenboek WHERE entryID=$whatever);
}
I'm sure the syntax on the mysql_query line isn't right...
The multiple database calls can be expensive if you're deleting lots of
information.
-Dash
-----Original Message-----
From: Davy Obdam [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 1:05 PM
To: Php Mailinglist; Php-Windows Mailing
Subject: [PHP-WIN] 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 Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
