How to use value from a pick list?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

TIA

Doug

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>";
echo "</select></td>";
?>


</body>
</html>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux