[RESOLVED] What am i doing wrong this time

[Megahertza]

Heres my code, i can't see a problem and it doesn't return any errors. A form with checkboxes names 1,2,3 and so on and a list with option such as delete,read,unread and so on again.

The script is ment to loop 10 times and update rows in a database or delete them if the user selected delete. Nothing get changed in my db.

include 'includes/connection.php'; // setup mysql db connection
if (isset($_GET[submit])){
$action = $_GET[mark];
$count = 1;
$max = 10;
	while ($count <= $max) {
		if ($_GET[$count] === "on"){
			if ($action === "delete"){
				$read_query = mysql_query("DELETE FROM messages WHERE mid = '$_GET[$count]'") 
				or die(mysql_error());;
			} else {
				$read_query = mysql_query("UPDATE messages SET status = '$action' WHERE mid = '$_GET[$count]'") 
				or die(mysql_error());;
			}
		}
	$count++;
	}
}

[bough]

Have you tried displaying the results of your SQL strings? ie

if ($action === "delete"){
$sql = "DELETE FROM messages WHERE mid = '$GET[$count]'";
echo $sql;
$read_query = mysql_query($sql) or die(mysql_error());;
} else {
$sql = "UPDATE messages SET status = '$action' WHERE mid = '$GET[$count]'";
$read_query = mysql_query($sql) or die(mysql_error());;
}

it is likely that the problem is there rather than PHP code if there is no errors

[Megahertza]

found my mistake,

UPDATE messages SET status = 'unread' WHERE mid = 'on' <= mid is spose to equale a number and not "on". thanks for your help