[RESOLVED] delete mail

[rbblue8]

hey,

i have a table called mail in mysql database and I use a php script to display the mail for the mysql table.

Within the php script there is an html table that displays the mysql data and within the html table I have a check box named message_id. it's value is the mesage id from mysql row (varrys from the message) and the value is generated by a while statment.

code here

   	while ($result=mysql_fetch_assoc($query))
		{
		$date=date("M d, Y", strtotime($result['date']));
		echo'
		<tr>
		<td><input name="message_id" type="checkbox" id="message_id" value="'.$result['message_id'].'" /></td>
      	<td>'.$result['subject'].'</td>
		<td>'.$result['message_from'].'</td>
		<td>'.$date.'</td>
      	<td>'.$result['status'].'</td>
    	</tr>';
		}
  echo'</table>';

my goal here is to have the user be able to select the check box's and then hit a buttion called delete, then have the script delete the message by message id.

there is no problem if they only selet one check box, but I would like them to be able to select more then one.

the question is... how do i get the multi check box values into an aray and then split it up for a query for the php script to pass it to the mysql server.

[rbblue8]

well i did it my self 🙂

here is my code 🙂

  //when the message is selected to be deleted and the delete selected buttion is hit.
  if(isset($_POST['delete_selected']) and isset($_POST['message_id']) and !isset($error))
  	{
	$delete=$_POST['message_id'];

while(list($k,$v) = each($delete))
	{
	$string=("DELETE from mail where message_id='$v'");
	$query=mysql_query($string, $db) or $error='<center id="error">Error while removing your messages<br />'.mysql_error().'</center>';
	}//end of while

if(!isset($error))
	{
	echo'Selected messages where removed';
	}//end of if statment
}//end of if statment

the trick was to make the check box an aray by added [] to the end of the check box name.

like so

<input name="message_id[]" type="checkbox" id="message_id[]" value="'.$result['message_id'].'" />

where message_id is the name of the check box and $result['message_id'] is the value givan out of the mysql query.

🙂