Entry

how do i extract elements from a database into a Select Form Field?

Mar 20th, 2002 01:37
Stefan Immel, Jan-Borge Landro,

Here's a little example in php.
<?php
$sock = mysql_connect("localhost");
$dbh = mysql_select_db("mydb",$sock);
$tab = mysql_query("select * from mytable",$sock);
$numrow = mysql_num_rows($tab);
for($i = 0; $i < $numrow; $i++)
{
   $row = mysql_fetch_row($tab);
   echo("<option value=\"$row[0]\">$row[1]</option>");
}
?>