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

2002-10-07 Thread Davy Obdam
: '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

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

2002-10-07 Thread Dash McElroy
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.

Re: [PHP-WIN] Deleting multiple items from database using checkboxes

2002-10-07 Thread Aitor
>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