[SOLVED] populate checkbox from mysql

[brem13]

i have a page where i am displaying text in textboxes from a mysql database and i also want to populate the checkboxes if there is a field in the database that reads 'Yes', and i cant figure out how to check the checkbox if featured = Yes?? any suggestions please??

 

$feat = $qry['featured'];

if($feat == "Yes")

$value= "checked";

else

$value = "";

 

    echo '<input type=hidden name=pic['.$counter.'] value='.$pic.'><input type=text name=comment['.$counter.'] value="'.$qry['comment'].'">Featured:<input type=checkbox name=featured['.$counter.'] value='.$value.'></td>';

[redarrow]

checked='$value' <<< in the form i think.

[Philip]

echo '<input type="checkbox" name="featured['.$counter.']" checked="'.$value.'">';

 

edit: my bad

[brem13]

thank you very much!!!

[wildteen88]

When checking a checkbox in HTML you should use checked="checked" rather than just checked.

[Psycho]

//Shorthand if/else to set the value of $checked to
// checked="checked" or empty string
$checked = ($feat == "Yes") ? ' checked="checked"' : '';

echo "<input type=\"hidden\" name=\"pic[{$counter}]\" value=\"{$pic}\" />
      <input type=\"text\" name=\"comment[{$counter}]\" value="{$qry['comment']}\" />
      Featured:<input type=\"checkbox\" name=\"featured[{$counter}]\" value=\"Yes\"$checked /></td>";