[SOLVED] mysql fetch with drop down menu

[Foser]

Im trying to do somekind of dropdown menu taking information from the database but im not quite sure how this could be done with my knowledge.

 

alright so lets say i have a table named: projects

SELECT name FROM project.

and it will put all the data found in a html drop down menu?

 

can anyone lead me in the right way?

 

thanks

[BillyBoB]

Sure i did this with my pm system for the users

 

<?php
$info = mysql_query("SELECT * FROM project");
echo("<select name=\"names\">");
while($infoarray = mysql_fetch_array($info)) {
  echo("<option>$infoarray[name]</option>");
}
echo("</select>");
?>

 

If you need more of an explanation just ask