Radio buttons

[Jeremias]

I use this code to generate a list of Items, I would like to do the same thing but with radio buttons. Can anybody help me with this because I'm getting nowhere 😕

<form method="post" action="<?php print $_SERVER['PHP_SELF']?>">
<select name="PressID" size="30" Multiple>


<?php

$db = mysql_connect("localhost", "root") or die 
("Kan niet verbinden: " .mysql_error());


mysql_select_db("studentinfo", $db) or die 
("Error=no connection to database");

$query="SELECT * from vakken";
$result=mysql_query($query);
while($vak=mysql_fetch_array($result))
{	print("<option value=\"$vak[0]\">$vak[1]\n");
}


?>

</select>

Thx,
Jeremias

[Yamakazi]

Is this what you mean?

while($vak=mysql_fetch_array($result)) 
    {    print("<input type=\"radio\" value=\"$vak[0]\" name=\"group1\"> $vak[1]\n"); 
    } 

BTW getting your variables in the manner of $vak[1] isn't a very good idea. If you ever have to drop or add a column the numbers might get scrambled and none of your code would work.

Also don't try to do a select * . . . just select what you need

select VakId as VALUE1, VakNaam as Value2

Then fetch, then $vak['VALUE1']

Just my 2 euro cents

PS: You can reply in Dutch if that would be easier 🙂

[Jeremias]

Thx for the info,
I'm gonna try it if it doesn't work out I'll ask some more questions.

Jeremias

EDIT: Thx, it works fine 🙂