Radio button > SQL > then SQL > Form

[phpsql_me]

I have a form which users enter information on, including text fields and radio buttons.
This info gets submitted to a DB, which I can do no problem.

However, when the user logs in to make changes to their profile I can't get the radio buttons to populate as checked as per their original selections the first time they chose them.

So I can get these radio buttons to pull their info from my DB and let the user know which selection they made on that particular set of radio buttons...

Does anyone know a standard syntax I can use throughout all my radio buttons? I assume I need a "if" statement, but im lost! HELP!!!!!

[Namadoor]

Well this is how I usually do it... if your form that enters information into the database looks like this...

echo "<input type='radio' name='choice' value='1' />Choice 1<br /><input type='radio' name='choice' value='2' />Choice 2<br /><input type='radio' name='choice' value='3' />Choice 3<br />";

Then I would do something like this...

//First get your $query, and get a $result

$ma = mysql_fetch_array($result);

echo "<input type='radio' name='choice' value='1' "; if ($ma[choice] == '1') { echo " selected='selected'"; } echo " />Choice 1<br /><input type='radio' name='choice' value='2 "; if ($ma[choice] == '2') { echo " selected='selected'"; } echo " />Choice 2<br /><input type='radio' name='choice' value='3' "; if ($ma[choice] == '3') { echo " selected='selected'"; } echo " />Choice 3<br />";

Hope this helps. 🙂

[phpsql_me]

Here this is what I have:

<input type="radio" name="more_locations" value="Yes">Yes 

<input type="radio" name="more_locations" value="No" >No 

So what I need now is a way to echo out the radio button that is checked...
Hope you understand what im getting at..?

[phpsql_me]

Can anyone please help me out!!!!!

[tomhath]

The example posted by Namadoor shows how to do it. Is there something about it you don't understand?

[phpsql_me]

This is what I've come up with so far, however it only "checks" the No radio button every time, it doesnt properly check to see if the user has selected Yes or No and "checks" that appropriate radio button.

Here is the code Im currently using now:

<?
 echo('<input type="radio" name="more_locations'.$more_locations.'" value="'.$myrow['more_locations'].'"' .  ( (mysql_fetch_assoc (mysql_query ("SELECT more_locations FROM techcompany WHERE logon_username = '".$_POST['user']."'") ) ) ? ' checked="checked"' : '') . ' />'.$myrow['more_locations'].'');
?>Yes</font><font size="1" face="Verdana"> 
&nbsp;&nbsp;
<?
echo('<input type="radio" name="more_locations'.$more_locations.'" value="'.$myrow['more_locations'].'"' .  ( (mysql_fetch_assoc (mysql_query ("SELECT more_locations FROM techcompany WHERE logon_username = '".$_POST['user']."'") ) ) ? ' checked="checked"' : '') . ' />'.$myrow['more_locations'].'');
?>No 

If anyone can help me out with the above it would be more than appreciated...

[phpsql_me]

Can anyone please take a look at my above code and let me know any suggestions in order to get this working some how...

please.....