Re: Creating a Dynamic dropdown menu from MYSQL db

[Paul Kalinka]

I'm doing the same type of thing Rich - I'm very new to PHP and Sql too. So anyways, in looking at what Bob posted, I couldn't figure out why it was giving the problems it was. So here are the changes I made to get it to work:

echo "<select name=\"search\">";
if(mysql_num_rows($result))
{
while($row = mysql_fetch_assoc($result))
{
echo "<option>$row[c_type]</option>";
}
}
else {
echo "<option>No Types Found</option>";
}

Good Luck & I hope to use this site more often - It's not too often you find current posts in a forum when you are trying to do something!