Multiple Delete with Checkboxes

[slevytam]

Hello,

I know this is probably a simple question but I am a little confused as to any easy way to do this.

I have a a list and each item in the list has a unique record number.

I have a checkbox for each item

I also have a delete button at the end of the list.

What I would like to happen is the user selects the items they would like to remove and then clicks delete. This in turn would run a script which would delete each of the select items out of the database.

Can anyone help with this?

Thanks,

--SL

[Pig]

name each check box the same thing: delete_me[] , and make the key for each item be the value for the check box

(you can rename it, but make sure you have the [] at the end.)

When the form is processed, it will turn delete_me into an array. Then you can simply loop through the array and run a delete query for each one.

[slevytam]

Great, thanks for your reply. Just one more question.

Is it possible to do this without posting? Could a php script be run from the delete button? ie a function would be included on the page. the function would delete the records and refresh the page. Or, is the array not created till post.

Thanks again,

--SL

[Pig]

The array is not created until the form is submitted. You can have the page submit to itself, and add an if() statement to run. eg:

if( isset($_POST['delete_me']) )
{
//run script here
}

[slevytam]

Thanks!