i am facing prob to create drop down menu using php mysql. i write a code but it showing only 1 row. i want to create a drop down menu from my database table and in drop down menu all data will be show in one drop down . please help me , Here is my code:
$result = mysql_query("SELECT * FROM members");
while($row = mysql_fetch_array($result)){
echo '<select>';
echo '<option>';
echo $b++;
echo '</option>';
echo '</select>';
i want a drop down list from my data base. thanks in advance