Radio button values associated with database values

run_GMoney

Can you make the value of say, 10 radio buttons, the entries from one column in a table? For instance, if I wanted those 10 radio buttons to have captions of 1, 2, 3, 4, etc and I had a column of 10 numbers in a table with the value of 1, 2, 3, 4, etc, could I assign those database values to the radio button value?

<input type="radio" value=1st Entry in Table />
<input type="radio" value=2nd Entry in Table />
.
.
.
etc

I won't know what these values are beforehand so I couldn't just use a SELECT...LIKE statement.

Thanks

stolzyboy

hmmm confused, more explanation please, or some code if you have any

run_GMoney

Looks like I'm looking for some sort of form array solution.

Picture this. In a database I have a table with 1 column:

Column1

1
2
3
4
5
6
7
8
9
10

I'd like to have radio buttons with the caption of these values like this:

o 1
o 2
o 3
o 4
o 5
o 6
o 7
o 8
o 9
o 10

Is that a little more clear? I don't have any code written yet. I was just curious if the concept was possible.

stolzyboy

try something like this, of course you could use a for loop also

<?
$query = "select column1 from table order by column1 limit 10;";
$result = mysql_query($query) or die(mysql_error());

while ($row = mysql_fetch_array($result))
{
?>
<input type="radio" value="<? echo $row['column1']; ?>"> <? echo $row['column1']; ?><br>
<?
}
?>

run_GMoney

Outstanding. Cool trick. I'm sure that will work wonderfully. Thanks again