Activating Radio Buttons with SQL data (NewB)

[determinedmoth]

Hi,
I have form built to allow people to edit their "profiles".

Their current details are loaded into text areas from MySQL. That's fine, but I have some table rows with true/false data... i.e, 1 or 0.

How do I generate radio buttons to automatically reflect this?

[devinemke]

mySQL does not have an actual boolean field type so i usually create a char(1) field (that defaults to NULL) and use "Y" for yes and NULL for no. as far as your form goes, i would suggest checkboxes instead of radios, that's what checkboxes are for: booleans

for eample, lets says we have a table like this:
users
user_id (INT)
first_name (VARCHAR)
last_name (VARCHAR)
email (VARCHAR)
mailing_list (CHAR(1))

where "mailing_list" is our boolean field. lets pull the record for user #123

$result = mysql_query('SELECT * FROM users WHERE user_id = 123');
$row = mysql_fetch_assoc($result);

echo '<form action="" method="POST">';

foreach ($row as $key => $value)
{
	$checked = '';

if ($key == 'mailing_list')
{
	$type = 'checkbox';
	if ($value) {$checked = ' checked';}		
}
else
{
	$type = 'text';
}

echo $key . ': <input type="' . $type . '" name="' . $key . '" value="' . $value . '"' . $checked . '><br>';
}

echo '<br><input type="submit" name="submit" value="submit"></form>';