RE: [PHP-WIN] Deleting multiple items from database using checkbo xes

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:info@davyobdam.com] 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:info@davyobdam.com -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php