[RESOLVED] Results from checkboxes

[birrd]

Hi,

Does anyone know how I can use foreach or forloop to get any selected checkboxes results and how can I query mysql to echo for the multiple values? 😕

<input type="checkbox" name="rating[]" value="1">
<input type="checkbox" name="rating[]" value="2">
<input type="checkbox" name="rating[]" value="3">
<input type="checkbox" name="rating[]" value="4">
<input type="checkbox" name="rating[]" value="5">

[djjjozsi]

like this:

 <form method="post" action="?">
<input type="checkbox" name="rating[]" value="1">
<input type="checkbox" name="rating[]" value="2">
<input type="checkbox" name="rating[]" value="3">
<input type="checkbox" name="rating[]" value="4">
<input type="checkbox" name="rating[]" value="5">
<input type="submit" name="submit" value="Submit">

</form>

<?php
if(!empty($_POST["rating"]))  {

$c=count($_POST["rating"])-1;
$q=0;
foreach($_POST["rating"] AS $keys)
{
	print "Selected IDs:  {$keys}  <br>\r";
	$in_id.="$keys";
	if($q==$c)
	break;
	else
	$in_id.=",";

	$q++; 
}

$sql="SELECT * FROM table WHERE field IN ($in_id)";
print $sql;


}

?>

[birrd]

It works!! Thanks for your kind assistance! =D ...