How do i delete multiple rows?

Anon

I have created a Holiday list using php
I want the comapny HR to be able to delete holidays from a list by the use of check boxes.
could anybody tell me how do i do this.
This may seem a very simple problem , i am a beginner
thanx
bye

Anon

Hi Praveen

Ye s it is very simple.

Make check boxes and put their value as holiday id from your holiday table.

Now on submit takes these checkbox values to other page and just fire a query DELETE from holiday table where holiday_id = '$id'

This is a simple logic..

Hope this helps you

Let me know if you need any further help.

Chanderjit

eduard

When multiple checkboxes are selected, theire sent seperated by the ';' sign (don't know the name in English (I'm Dutch)) so you can user explode() and place all ID's in an Array. then read the array

for (blah blah)
{
$Query = "Delete blah blah where field = '$ID'

Execute SQL over and over again

}

$Query = "DELETE FROM blah blah WHERE";
for (blah blah)
{
$Query .= "field = '$ID' OR";
}

Execute SQL once

eduard

Hmmm, okay!!! this sounds a lot simpeler! Does this also work with Netscape?

Anon

Ofcourse it works in Netscape..........

Well i have explain the logic.. how the logic should be.

Chanderjit