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>";
?>