php/mysql delete

[ryza_]

Hello

this probably sounds stupid but i want to know how to delete multiple items with checkboxes, this forum lets you do it in the private message system, you can select multiple messages with check boxes then click delete.

so what i really want to know is how do you get the querys so you know which messages are selected?

any help would be appreciated.

ryza

[router]

If you put...
for ($i=0;$i<$total;$i++)
{ echo "msg $i <input type='checkbox' name='msg_to_delete[]' value='$i'><br>";
}

In "value" you can save the value that you want, of course. Using that code, you have an array named msg_to_delete with all numbers of message to delete ($i).

In the next page...
$msg_to_delete = $_POST['msg_to_delete']
And you can use $msg_to_delete like an array
..
Does it hepl you?
Good luck!
Router

[stezz]

you assign a value to each checkbox.. the value of each checkbox should be the ID value of the data it represents in the database. On this site, they've more than likley printed the checkboxes by their values straight from the DB..

Say there were 10 entries in the DB that u wanted to print out, each entry with it's own unique ID in the DB. So.. u loop through and print the 10 results out..

say u check 5 of them for deletion.. u could make an array that holds each value of the 5 checkboxes.. then using that array.. loop through with a delete query to the datatbase deleting each item by it's unique ID (the value of each checkbox).

And there you have it 😉

Hope Iv'e helped rather than confused you!

Regards, Stezz.