MySQL dynamic drop down menu

I make a litlle corections, but i did not find any error.
Can you you te me what was wrongm what error you get ?

Code:
<HTML> 
<HEAD> 
<TITLE>show car</TITLE> 
</HEAD> 
<BODY> 
<FORM action="http://localhost/view.php" method="GET"> 

<?php 
$host = "localhost"; 
$user = "root"; 
$pass = ""; 
$db = "DVD"; 
$table = "list"; 

$link = mysql_connect($host, $user, $pass); 
if(!$link) die(mysql_error()); 
$select = mysql_select_db($db); 
if(!$select) die(mysql_error()); 

$query = "SELECT name FROM list"; 
$result = mysql_query($query); 
if(!$result) die(mysql_error()); 

echo "search:<br>\n"; 
echo "<select name=nam>\n"; 
echo "<option value=''> </option>\n"; 
while($row = mysql_fetch_array($result)) 
{ 
echo "<option value='$row[name]'>$row[name]</option>\n"; 
} 
echo "</select>\n"; 
mysql_connect(close); 
?> 

<input type="submit" value="submit"> 
</FORM> 
</BODY> 
</HTML>
 
Back
Top