I'd like to have a form that does the following:
User picks a site from a dropdown list from a MySQL db (that works - code below, thanks to all those on the web who posted code for this).
Once the value is selected, a second query is run using the site as the 'where' clause and the results are displayed back to the user.
Any help for this mysql, php, htlm noob. I think once I get this bit, I'll be able to move forward with more interesting and complex code.
ps - if this message shows up 3 times, my apologies but I've been having trouble posting.
<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>";
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php