Dynanmic menu selects from MySQL

Anon

Please help...does anyone know the syntax for creating a pull down menu where the selects are rows from a MySQL column. Please help....thanks...

cordex

Pretty broad question there, Ryan.

In fact, very little info given at all. don't expect a perfect answer:

echo "<SELECT NAME=selectbox>\n<option value=''>Select One\n";
while($query_ar = mysql_fetch_array($query_rs))
{
echo "<option value='".$query_ar[value]."'>".$query_ar[displaytext]."\n";
}
echo "</SELECT>";

Anon

Sorry to be so vague...I'm a newbie...how do I define the query? My table name is sampledaycare_classes and the column name is class_name. Thanks for your help, I really appreciate it....

cordex

$query_st = "SELECT * FROM sampledaycare_classes";
$query_rs = mysql_query($query_st);

You have initiated communication with your DB, right?

-Ben

Anon

sorry to be such a pest....this is what I have so far and I am getting an error...

<head>
<title>Calendar Input Form</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<?php
$Host="localhost";
$User="click";
$Password="*******";
$DBName="clickdb";
$TableName="sampledaycare_classes";

$Link=mysql_connect ($Host, $User, $Password);

$query_st = "SELECT * FROM sampledaycare_classes";
$query_rs = mysql_query($query_st);

echo "<SELECT NAME=selectbox>\n<option value=''>Select One\n";
while($Row = mysql_fetch_array($query_rs))
{
echo "<option value='".$Row[value]."'>".$Row[displaytext]."\n";
}
echo "</SELECT>";

mysql_close ($Link);
?>
</body>

The error is as follows: Warning: Supplied argument is not a valid MySQL result resource in ..... on line 21 which is the while looping line....

Thanks again!

cordex

The table is probably empty. You'll also want to change

this:
echo "<option value='".$Row[value]."'>".$Row[displaytext]."\n";

to this:
echo "<option>".$Row[class_name]."\n";

I was giving you placeholders.

Anon

Excuse my ignorance...this is my last question...I made the changes and I am still getting that error message....

Also, do I still need to use Form Action or does that syntax you gave me do that for php?

I promise this is my last posting on this...

Thanks,
The Pain

cordex

Asking specific questions is not a pain. It's the broad "how do I do all of this?" that can be irritating. Keep 'em coming as long as it's not working.

I just gave you the code for the select box. The rest of the form is up to you.

Does your table contain any data? Lack of data could cause the error (I didn't add any error parsing - if you need it, ask).

Also, if you need an answer to this question soon, I only pop to this forum every once in a while at work. If you need a question answered, check out: http://www.hvt-automation.nl/yapf/

-Ben

Anon

you never did a mysql_select_db...