I want to:
Populate a dropdown list with values from a MySQL db (done and working).
Use the selected value as the 'where' clause in a second query.
Return the results and display them to the user.
Any pointers are appreciated - noob^3 (html, mysql, and php).
Doug
Code that I'm using:
<html>
<body>
<?php
// connect to db
$db = mysql_connect("localhost");
mysql_select_db("test",$db);
// build query
$sitequery = "SELECT site from sitedata order by site";
// generate result set
$siteresult = mysql_query($sitequery);
// use results
echo "Select a site from the list below: <br><br><select name='site'>";
while($siterow = mysql_fetch_array($siteresult))
echo "<option value='".$siterow["site"]."'>"
$siterow["site"]."</option>";
echo "</select></td>";
?>
</body>
</html>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
