Hi,
I try to retrieve information from my MySQL database. The main.html file produces a drop-down list and according to the option chosen a MySQL output should appear.
Unfortunately, it seems that the problem is that the $_GET['choose'] is empty.
How can I solve it.
Li.
MAIN.HTML
<html>
<head>
<title> Select Number </title>
</head>
<body>
<form action="http://localhost/out.php" method="GET" >
Choose Number:<br>
<select name=choose">
<option value=" "> </option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<br>
<input type="submit" value="Click">
</form>
</body>
</html>
OUT.PHP
<html>
<head>
</head>
<?php
$no=$_GET['choose'];
$db_host = 'localhost';
$db_user = 'root';
$db_pass = '';
$db_name = 'collection';
$db_table = 'main';
$connection=mysql_connect($db_host,$db_user,$db_pa
ss);
mysql_select_db($db_name,$connection);
$result = mysql_query ("SELECT * FROM list WHERE no='$no'", $connection);
while ($row = mysql_fetch_row($result))
{
for ($i=0; $i<mysql_num_fields($result); $i++)
echo $row[$i] . " ";
print "<br>";
}
mysql_close($connection);
?>
</body>
</html>
