Php > Database Related

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