Help: Stop Foreach Looping

[ipwnzphp]

I have this script i am coding and it just repeats the checkboxes over and over... i need it to only show the checkboxes for each amentie once and show checked if it is in the database...

 

 

   <? 

    $result = mysql_query("SELECT * FROM amenties ORDER BY id DESC");
while ($row = mysql_fetch_array($result)) {

foreach ($explode_amen as $aman) {

if($aman == $row['id']) {
$picked = "checked";
} else {
$picked = "";
}	 

?>
    
    <div style="float:left; width:210px;"><input name="amen[]" type="checkbox" id="amen[]" style="width:25px;" value="<?=$row['id']?>" <?=$picked?> /><?=$row['amen_name']?></div>
   
    <? 
 } 
 }
?>

[btherl]

Instead of the foreach loop you can use this:

 

if (in_array($row['id'], $explode_amen)) {
  # Yes, it's checked
} else {
  # No it's not checked
}

 

That should fix the problem.  The problem is that your checkbox display code is inside the foreach loop.

[ipwnzphp]

Thanks! worked like a champ!!