Mysql Radio buttons

[Anon]

I get data from a mysql data base here is the code basically I have a while loop and in the while loop I have my two columns
echo $row["name"]; echo $row["smallname"];

I want to put a radio button in them in a format such as this (of course this dosen't work

echo "<input type='radio' name='select' value='$row[/"smallname/"]'>$row[/"name/"]";

I need that in the loop so that way it grabs all the values from the DB.

any ideas?

John

[Anon]

Yep. Do you not mean \ instead of /?

[buck2bcr]

Here is something that I have used for radio buttons. I build the query for the database and get the result with:

$mysql_result = mysql_query($query_done, $mysql_link);

while($row = mysql_fetch_row($mysql_result))
echo"
<input type=\"radio\" value=\"$row[0]\" checked name=\"edit_row\">";

Then I use the while loop to get each row and do the output. I think you can use mysql_fetch_array and use the field name instead of how I did it. I just like using the fetch_row.

HTH

Buck

[buck2bcr]

Buck wrote:

Here is something that I have used for radio buttons. I build the query for the database and get the result with:

$mysql_result = mysql_query($query_done, $mysql_link);

while($row = mysql_fetch_row($mysql_result))
echo"
<input type=\"radio\" value=\"$row[0]\" checked name=\"edit_row\">$row[1]";

I forgot to put the second variable in. Now you get a radio button with text next to it, $row[1] or what ever.

Sorry

[Anon]

A million Thank you's it worked superb

John