How can i delete multiple row through PHP coding

taha_elearner · October 28th, 2005, 04:46 AM

I am working on a project for my college , I have a problem in message page where I retrieve data from database and I also give delete option on this page so my prepare code can delete single row at a time so I want to delete multiple rows at a time

Plz help me in this.

Allah watching you

anshul · October 28th, 2005, 05:33 AM

Consider SQL syntax:

'DELETE FROM table_name' deletes all rows.

'DELETE FROM table_name WHERE condition' delete 1 or more rows matching the condition. If conditions are many, call this rule many times.

You may show 'checkbox' or 'multiple select' for 'admin' and when he/she selects (unique) IDs, records will get deleted may be by a single statement in a loop.

This is simple.
http://www.mediasworks.com/tutorials...l_tutorial.htm

`~@#\^%&*/\.<.\/-|+|_!:;..=?>
Support Indian students' finances http://scholarship.mediasworks.com/