Drop down menu from sql database.

[simjay]

I havent done one of these before, can any one help?

echo "<select name='book_topic'>
<option value='$topic_id'>$topic_name</option>
</select>"

Thank you

[Len Whistler]

This might help.

<select name="">
<?
while($row = mysql_fetch_array($sql)){
echo "<option value=\"$row[0]\">$row[0]";
}
?>
</select>

[simjay]

That just comes up with a new dropdown menu for each one, i now have a new drop down for each entry.

[Len Whistler]

That just comes up with a new dropdown menu for each one


Title of thread Drop down menu from sql database.

[simjay]

well done you read the title

[Len Whistler]

well done you read the title

So what do you want?

[simjay]

ONE drop down menu with all the options from the table. Not a drop down menu for each option. Done it now thank you any way!!!!!!!

[rafiki]

try looking up mysql_num_rows
and add something like

while ($rows <= mysql_num_rows($sql)) {
echo "<option value=$row[0]> $row[0]</option>";
$row++
}