Check boxes and radio buttons

[JakesSA]

Hi all

Can someone please expain to me who to populate a check box or radio button from a database.

Heres the senario

I connect to db, I pull out the data with mysql_fetch_array().

$formVars["firsname"]= $row["firstname"];

I then load the data into the form eg:

<input name="firstname" type="text" value="<?PHP echo $formVars["firstname"]; ?>" size="35">

This works fine and is simple enough. But how would I do the same to load a check box or radio button. eg letting a viewer amend his details.... deciding between html or text?

Thanks in advanced

[dar-k]

I hope this answers your question:

CHECKBOX:

<input type="checkbox" name="HTML" value="1" <?php if (isset($formVars['HTML']) && $formvars['HTML']==1) { echo 'checked'; } ?>>

-

RADIO:

<input type="radio" name="HTML" value="text" <?php if (isset($formVars['type']) && $formvars['type']=='text') { echo 'checked'; } ?>>
<input type="radio" name="HTML" value="html" <?php if (isset($formVars['type']) && $formvars['type']=='html') { echo 'checked'; } ?>>

[JakesSA]

I still cant get it to populate the radio buttons. Please can someone help

Let me give you the pieces of code to show you what I have done.

if(!($result = @ mysql_query($query_fetch, $connection)))
    die(mysql_error());

$row = mysql_fetch_array($result);

//reset(assoc array) and inject data
$formVars = array();
$formVars["email"] = $row["email"];
$formVars["firstname"] = $row["firstname"];
$formVars["lastname"] = $row["lastname"];

/* The problem that I am having is with the next value. It eithier 
has the value of html or text. I have to populate one of two radio
 buttons with the corrosponding values. So that the user can ammend his his details if needed */

$formVars["HTML_Text"] = $row["HTML_Text"]; 

-------------------------latter on in the script-----------------------------

<input type="radio" name="HTML_Text" value="text"
<?php if(isset($formVars['HTML_Text']) && $formVars[''HTML_Text'']=='text') { echo 'checked'; } ?>>

<input type="radio" name="HTML_Text" value="html"
<?php if(isset($formVars['HTML_Text']) && $formVars[''HTML_Text'']=='html') { echo 'checked'; } ?>>

-----------------------------------------------------------------------------------

So if some one can please help me, I would appriciate it.

[JakesSA]

sorted mate

😃 😃 😃