Radio buttons and databases

Radon3k

How do I get a form to show the value from a field in the database on a radio form? This is what I have but it doesn't work:

$getperms = "SELECT * FROM editorialperms";
$getpermsquery = mysql_query($getperms) or die(mysql_error());
$permsrow = mysql_fetch_array($getpermsquery);
$mustapprove = $permsrow['mustapprove'];
?>
<form method="post" action="<?$PHP_SELF?>">
	<?php
	echo("
	<table border='0' cellspacing='0' cellpadding='0' width='100%'>
		<tr>
			<td>Editorials must be approved?</td>
			<td>Yes<input type='radio' name='editapproval' value='$mustapprove'>&nbsp;
				No<input type='radio' name='editapproval' value='$mustapprove'></td>
		</tr>
		<tr>
			<td></td>
			<td><input type='submit' name='submitapproval' value='Validate'></td>
		</tr>
	</table>
</form>
");

Thanks. 🙂

barand

Assuming mustapprove contains 'Y' or 'N'

$getperms = "SELECT * FROM editorialperms";
$getpermsquery = mysql_query($getperms) or die(mysql_error());
$permsrow = mysql_fetch_array($getpermsquery);
$mustapprove = $permsrow['mustapprove'];
$checkY = $mustapprove=='Y' ? 'checked' : '' ;
$checkN = $mustapprove!='Y' ? 'checked' : '' ;

?>
<form method="post" action="<?$PHP_SELF?>">
	<?php
	echo("
	<table border='0' cellspacing='0' cellpadding='0' width='100%'>
		<tr>
			<td>Editorials must be approved?</td>
			<td>Yes<input type='radio' name='editapproval' value='Y' $checkY> 
				No<input type='radio' name='editapproval' value='N' $checkN></td>
		</tr>
		<tr>
			<td></td>
			<td><input type='submit' name='submitapproval' value='Validate'></td>
		</tr>
	</table>
</form>

JehovahsWord

You would just do an if statement, say $mustapprove has either yes or no in it:

print("yes<input type=\"radio\" name=\"editapproval\" value=\"yes\"");
if ($mustapprove == "yes") {
print(" checked=\"checked\"");
}
print(" />\n");
print("no<input type=\"radio\" name=\"editapproval\" value=\"no\"");
if ($mustapprove == "no") {
print(" checked=\"checked\"");
}
print(" />\n");

or, you could do:

switch ($mustapprove) {
case "yes":
print("yes<input type=\"radio\" name=\"editapproval\" value=\"yes\" checked=\"checked\" />\n");
print("no<input type=\"radio\" name=\"editapproval\" value=\"no\" />\n");
break;
case "no":
print("yes<input type=\"radio\" name=\"editapproval\" value=\"yes\" />\n");
print("no<input type=\"radio\" name=\"editapproval\" value=\"no\" checked=\"checked\" />\n");
break;
}

or anything of that sort.

Brandon

edit: sorry! I didn't see someone already answered just now

Originally posted by Radon3k
How do I get a form to show the value from a field in the database on a radio form? This is what I have but it doesn't work:

$getperms = "SELECT * FROM editorialperms";
$getpermsquery = mysql_query($getperms) or die(mysql_error());
$permsrow = mysql_fetch_array($getpermsquery);
$mustapprove = $permsrow['mustapprove'];
?>
<form method="post" action="<?$PHP_SELF?>">
	<?php
	echo("
	<table border='0' cellspacing='0' cellpadding='0' width='100%'>
		<tr>
			<td>Editorials must be approved?</td>
			<td>Yes<input type='radio' name='editapproval' value='$mustapprove'>&nbsp;
				No<input type='radio' name='editapproval' value='$mustapprove'></td>
		</tr>
		<tr>
			<td></td>
			<td><input type='submit' name='submitapproval' value='Validate'></td>
		</tr>
	</table>
</form>
");

Thanks. 🙂 [/B]

Radon3k

Is there a way to use the code I have or do I have to re-do it?

JehovahsWord

hi,

Well you can keep your code the same till you get to where the radio buttons are, then you put in the code which works. just of course you need to take the value from the database...

Brandon

Originally posted by Radon3k
Is there a way to use the code I have or do I have to re-do it?

Radon3k

Sorry but I'm confused on the code presented to me by both of you. I just need the value retrieved from the database and displayed in the radio button (One of them has to be checked according to whichever one is in the database). Sorry for the confusion.

barand

That's what the solutions do.

It is no use giving both radio buttons the same value.
Give one a value 'Y', the other 'N'
Set one checked by putting 'checked' inside the input tag according to the value of the field 'mustapprove'.