Php Programming Code Examples Php > Database Related Code Examples List Box bound to mysql List Box bound to mysql <?php $link = mysql_connect("mysql", "user", "password"); mysql_select_db("DATABASE"); $query = "SELECT FIELD FROM TABLE"; $result = mysql_query($query); print "<SELECT name=item>"; while ($line = mysql_fetch_array($result)) { foreach ($line as $value) { print "<OPTION value='$value'"; } print ">$value</OPTION>"; } mysql_close($link); print "</SELECT>"; ?>
