Re: Deleting multiple items from database using checkboxes

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" <info@davyobdam.com> To: "Php Mailinglist" <php-general@lists.php.net>; "Php-Windows Mailing" <php-windows@lists.php.net> 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:info@davyobdam.com > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >