: 'Davy Obdam'; Php-Windows Mailing
Subject: RE: [PHP-WIN] Deleting multiple items from database using
checkboxes
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 synta
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.
>my querylooks like this :
>DELETE FROM gastenboek WHERE entryID=$dele .
I think that the mySQL query should look like:
DELETE * FROM gastenboek WHERE entryID=$dele
so, you should do something like this:
DELETE $thinks_to_delete FROM gastenboek WHERE entryID=$dele
After the "DELETE" you must