Creating dynamic menus

Anon

Hi All;
Need some help here.

How do I create a dropdown menu that pulls it's categories and links from a MySQL database? I need a dropdown menu that takes the category title and ID from a MySQL table and then displays certain fields when clicked. I am using this so far.

"
print("<TD width=\"10%\" VALIGN=\"top\" ALIGN=\"left\">");
$results = mysql_query("SELECT name, id FROM category WHERE parent=5 ORDER BY name");
print "<select name=\"name\">\n" ;
while ( $row = mysql_fetch_row($results) )
print "<option>".htmlspecialchars($row[0])."</option>\n" ;
print "</select>\n" ;
print("</TD>\n");
"

This gets the menu poulated but I can't get them to act as links.

HELP

Shawn

Anon

You need to add the value for each option.

print "<option value=\"".$row[n]."\">".htmlspecialchars($row[0])."</option>\n";

Where n is the field number for the id.

Anon

Hows it going,
Funny I was just doing this this morning, what I like to do is (depending on if the data (that is your number 0,1,2 and the data you want in the dropdown)) is

$result=mysql("your_db","select * from your_table where etc",$handle);
//check to see if there are results (wont put that here)

assuming that there are,
while($ans=mysql_fetch_array($result)){
echo"<OPTION>";
echo $ans["num_data"], $ans["data"];
echo"</OPTION>";}

Of course all of this is in your select dropdown HTML
if you want to put all of that info in a link, just put an anchor inside of the <OPTION> tags.

Anon

rod didn't you made a typo ?
you wrote :
print "<option value=\"".$row[n]."\">" ...

Shouldn't it be :
print "<option value=\"".$row[0]."\">" ...

Correct me if I'm wrong .

JBL