How to use a value from a pick list?

[dogu]

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($si tequery);

// use results
echo "Select a site from the list below: <br><br><sele ct name='site'>";
while($siterow = mysql_fetch_arr ay($siteresult) )
echo "<option
value='".$siter ow["site"]."'>".$siter ow["site"]."</option>";
echo "</select></td>";
?>

</body>
</html>

[dogu]

Re: How to use a ... figured it out.

Finally got the pieces to work together. For those of you who know what
you're doing, the following falls into the 'duh!' class. For anybody
else new to the game, I hope this helps.

Todo:
Disconnect the MySQL session.
Figure out a way to pass the db connection to the 2nd file rather than
reconnecting.
Convert everything to functions where it makes sense.
Play with other other form construction - embed php in html rather than
embedding html in php, figure out other methods to pass data between php
and html.

Dogu


Two files, both php.

First one returns a list of sites and launches the second form.
The second one uses the selected site name to return the password.

File 1:

<html>
<body>
<form action="getpw.p hp" method="get">

<?php

// connect to db
$db = mysql_connect(" localhost");
mysql_select_db ("test",$db) ;
$dbtbl = mysql_select_db ("test",$db) ;

// build query
$sitequery = "SELECT site from sitedata order by site";

// generate result set
$siteresult = mysql_query($si tequery);

// use results
echo "Select a site from the list below: ";
echo "<br><br>";
echo "<select name='website'> ";
while($siterow = mysql_fetch_arr ay($siteresult) )
echo "<option
value='".$siter ow["site"]."'>".$siter ow["site"]."</option>";
echo "</select></td>";

?>
<br>
<br>
<input type="submit" />
</form>
</body>
</html>

File 2 - getpw.php
The site you selected is <?php echo $_GET['website']; ?>.
<br>
<br>
The password is

<?php
// connect to db
$db = mysql_connect(" localhost");
mysql_select_db ("test",$db) ;

// build query
$pwquery = "SELECT password from sitedata where
site="."\"".$_G ET['website']."\"";
// generate result set
$pwresult = mysql_query($pw query);
$sitepw = mysql_data_seek ($pwresult,0);
while($sitepw = mysql_fetch_arr ay($pwresult))

echo $sitepw["password"];
echo "<br>";
echo "query is ".$pwquery;
?>
dogu wrote:[color=blue]
> 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($si tequery);
>
> // use results
> echo "Select a site from the list below: <br><br><sele ct name='site'>";
> while($siterow = mysql_fetch_arr ay($siteresult) )
> echo "<option
> value='".$siter ow["site"]."'>".$siter ow["site"]."</option>";
> echo "</select></td>";
> ?>
>
> </body>
> </html>[/color]