repeating checkboxes problem

[andrew_m]

Hi Folks,

 

I am looping through a recordset ($result) containing different languages which I convert to values of html checkboxes, I want to compare the recordset values to array values ($arr_languages_spoken) and check the checkboxes that match.  I think I am close, the code I have checks the right boxes but duplicates every value from the recordset so I have 2 of each checkbox, any help would be appreciated, thanks.

 

MY CODE

while($row = mysql_fetch_array($result))
{
    foreach ($arr_languages_spoken as $value) 
       {
           if ($value == $row['language'])
           {
            echo "<input type=checkbox name=languages_spoken_1 value=".$row['language']." CHECKED/>".$row['language']."  ";
           }
           else if ($value != $row['language'])
           {
           echo "<input type=checkbox name=languages_spoken_1 value=".$row['language']." />".$row['language']."  ";
           }
     }
}