Hi,
I think I have something. I think what you want is a self-posting page.
The follow example kind of does close to what you want.
Get rid of the arrays and use the MySQL commands and I think you will have something you can use.
I hope this helps.
Here is that code:
<html>
<head>
</head>
<body>
<?php
$key = $_GET['$key'];
?>
<p>Input animal type:</p>
<form id="form1" action="<?php echo $_SERVER['PHP-SELF'] ?> " method="get">
<p>Input1: <input type="text" name="key" size=40></p>
<p><input type="submit" value="Submit" size=40></p>
</form>
<?php
$key = $_GET['key'];
if (!is_null($key)) {
$row[0] = "Cow";
$row[1] = "Deer";
$row[2] = "Fox";
$row[3] = "Cat";
//$result = mysql_query("SELECT * FROM animal_record WHERE Key='$key'");
$i = 0;
echo "<p>Results:</p>";
echo "<form>";
echo "<select name='category'>";
//while($row = mysql_fetch_row($result))
while($i < 4){
echo "<option>$row[$i]</option>";
$i += 1;
} /* End while */
echo "</select>";
echo "</form>";
} /* End if */
?>
</form>
</body>
</html>
