[SOLVED] Radio Boxes from database?

[wwfc_barmy_army]

Hello.

 

I've got this code:

 

  
<?php

$result = mysql_query("SELECT show FROM optionaltext WHERE id= 1");
  
$row = mysql_fetch_array($result);
$show= $row['show'];
// So $show will have the value Y or N.
?>

<p>
    <label>
Would you like this page to be displayed?<br/>
      <input type="radio" name="show" value="Y" />
      Yes</label>
    <br />
    <label>
      <input type="radio" name="show" value="N" />
      No</label>
    <br />
  </p>

 

It's a radio button group, one being Yes and one being No with the values Y and N.

 

I have a database field which is an Enum type which will either be Y or N. How would i go about making it so when i get the value that is already in the database it automatically selects Yes if the value in the field is Y and No if N?

 

Thanks.

[MadTechie]

try this

 

  
<?php

$result = mysql_query("SELECT show FROM optionaltext WHERE id= 1");
  
$row = mysql_fetch_array($result);
$show= $row['show'];
// So $show will have the value Y or N.
$sel = ($show == "Y")?"checked=\"checked\"":"";
echo "Would you like this page to be displayed?<br/>";
echo "option<input type=\"radio\" name=\"show\" value=\"Y\" $sel>";
echo "option<input type=\"radio\" name=\"show\" value=\"N\" $sel>";

?>