CHeckbox problem

[aznjay]

I don't know how to make it delete different data from mysql. It only deletes one data each tyme the checkbox is checked. I want it to delete the selected amount checkboxes that wanted to delete. Thank for who ever can figure this out.

$userses = $_SESSION['edithtml'];
 echo "<table cellpadding=0 cellspacing=0 border=1>\n";
	echo "<form action=deletemsg.php method=post>\n";
$query = "SELECT * from guest WHERE user_name='$userses'";    

$show = mysql_query($query);    

while ($row=mysql_fetch_array($show))  

{ 
	echo "<tr>\n"; 
	echo "<td>\n";
	echo "<input type=checkbox name=deleted[] value=$row[guest_id]>\n";
	echo "<td>\n";
  echo "$row[guest_message]";
	echo "</td>\n";
	echo "<tr>\n";
	echo "<td>\n";
  echo "Posted by:<a href=viewpage.php?username=$row[user_name]>$row[user_name]</a>";
	echo "</td>\n";
	$guest_time = $row['guest_time'];
	$datefromdb = $guest_time;
$year = substr($datefromdb,0,4);
$mon  = substr($datefromdb,4,2);
$day  = substr($datefromdb,6,2);
$hour = substr($datefromdb,8,2);
$min  = substr($datefromdb,10,2);
$sec  = substr($datefromdb,12,2);
$orgdate = date("l F dS, Y h:i A",mktime($hour,$min,$sec,$mon,$day,$year));
	echo "<td>\n";
  echo "Date: $orgdate";
	echo "</td>\n";


}  

 echo "</table>\n";
	echo "<input type=\"submit\" name=\"submit\" value=\"Delete GB Entries\">\n";
	echo "</form>\n"; 
?>

$mama = $_POST['deleted[]'];
mysql_query( "DELETE FROM guest WHERE guest_id = ''" ); 

header ("Location: [url]http://www.chaoticillusions.com/community/delete.php[/url]"); 
exit;
?>

[zhabala]

The second script, which is to delete the records is a bit wrong. Should look like this:

$mama = $_POST['deleted']; 
foreach ( $mama as $guest_id ) {
    mysql_query( "DELETE FROM guest WHERE guest_id = $guest_id" );
}

header ("Location: <a href="http://www.chaoticillusions.com/community/delete.php" target="_blank">[url]http://www.chaoticillusions.com/community/delete.php[/url]</a>"); 
exit; 
?>

Your version deletes only records where guest_id = '', and does nothing with records containing checked guest_ids.

Zdenek