Hi everyone!
I would like to create a drop down list with the info in my database.
I would also like to have more options so it will filter down to many
rows of data displayed then filtered down to a few rows of data that
said user is looking for.
Kind of like select a state then in the next box you can select the city.
but first thing is first.....
I have tried a few things out there that I searched for but everything
I tried it will not populate the drop down list with the data in my
database.
So I know it somewhere along the lines of:
$query = mysql_query("SELECT root FROM training");
echo "<form action=something.php method=POST><select name=Field>";
while ($r = mysql_fetch_array($query))
{
$user = $r["username"];
echo "<option value=$user>$user</option>";
}
echo "</select>";
or something like that but nothing populates....
What is the proper code to get this done to populate and display what
I select from the drop down menu?
Say my DB name is: TUBA
My table name is: FLUTE
and I have xxx amounts of rows to filter through with three columns in
my mysql db.
Does that all make sense?
Thanks in advance!
You all rock!!
sb
--
AOL IM: Jestrix1
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
