checkboxes and php

[robsgaming]

Right now I have an internal messaging system that I scripted for my site users. To erase messages they click on an "X" image, it shows a page saying the message was erased, then it says click here to go back to the messages list.

I want to know how to show checkboxes next to each message, then show a button at the bottom that when delete is pressed, the messages that are checked off will be erased.

Please help if possible. I have NO idea how to do this and how to name checkboxes, etc.

Table fields are:

id, fromname, subject, message, date, toname, readmsg

readmsg has a value of "Y" or "N" if the message has been read or not. Nothing important in this case...

[PHPThorsten]

your checkboxes have a parameter called "name", this name will appear in php as the variable name.

set this name to "msg[$id]", so it will be an array in php with the id of the message as array key.
then, when delete button is pressed,

$msg_to_delete = $_REQUEST['msg'];

will give you an array "$msg_to_delete". the key's of this array are, like said above, the message id's you have to delete.
now you need an function that makes you a new array with the key from this array as a VALUE.
that's easy:

while(@list($key, $val)=@each($msg_to_delete)) {
    $arr_msg_to_del[] = $key;
}

now you need to run a loop reading this new array that creates an sql statement and executes this what deletes all entry from DB with ID = $arr_msg_to_del[X]

for($i = 0; $i < count($arr_msg_to_del); $i++)
{
  $id = $arr_msg_to_del[$i];
  $query = "DELETE FROM table WHERE id = '$id';";
  mysql_query($query);
}

ok, this will only work if you use mysql, but i hope you understand how to realise it.

Bye bye

Thorsten