<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>