Retrieve data from database and place in radio button for editing

[ransome]

Dear all,

In a table of user profile, the entry for sex field is either "Male" or "Female";

In a PHP page; the data is retrieved ;

How can I code so that the data is mapped to a HTML form which the sex field is represented by 2 radio ; so that I can edit by clicking the radios?

With regards,

Ransome

[jpmoriarty]

for the radio buttons to display the right one:

assuming the variable coming from the database is $sex (with values either M or F):

echo "<input type=\"radio\" name=\"sex\" value=\"M\"";
if ($sex = "M")
  echo " SELECTED";
echo ">Male\n";
echo "<input type=\"radio\" name=\"sex\" value=\"F\"";
if ($sex = "F")
  echo " SELECTED";
echo ">Female\n";

Then you'd just need an update button, and have the form's action as "update.php". Then in update.php you'd call an sql update statement to add the new value.