dropdown data from sql

[ddtpmyra]

Im used of doing a dropdown menu on a hardcoded choices...

 <b>Select Category:
   <select name="category">
                 <option value="Category 1">Process Change</option>
                 <option value="Category 2">Product Update</option>
  </select></b>

but how can you do a dropdown menu using query result. Can somebody show me how I would apprecite this :)

[pbmods]

Heya, ddtpmyra.

Here you go:
php dropdown from query - Google Search

[ak1dnar]

Here are more of them. from Bytes Forum.
site:bytes.com php drop down - Google Search

[ddtpmyra]

I found my way how to work on this... just in case for other bytes members looking for formats or scripts

//Connect to the database
 
//THIS CHECKS IF YOU’VE ALREADY SELECTED CONTACT NAME FOR INSTANCE
if(!isset($_GET['CONTACT'])){ 
$Var ='%'; 
} 
else 
{ 
if($_GET['CONTACT'] == "ALL"){ 
$Var = '%'; 
} else { 
$Var = $_GET['CONTACT']; 
} 
} 
 
//THIS PUTS A FORM WITH A drop down BOX TO SELECT THE CONTACT AND SHOW THE CONTACT IF ALREADY SELECTED 
 
echo "<form action=\"XXX.php\" method=\"GET\"> 
<b>Contact</b>"; 
$res=mysql_query("select * from contacts"); 
if(mysql_num_rows($res)==0){ 
echo "there is no data in table.."; 
} else { 
echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<select name=\"CONTACT\" id=\"CONTACT\"><option value=\"ALL\">Select</option>"; 
for($i=0;$i<mysql_num_rows($res);$i++) { 
$row=mysql_fetch_assoc($res); 
echo"<option value=$row[CONTACT]"; 
if($Var==$row[VarietyID]) 
echo " selected"; 
echo ">$row[fname]</option>"; 
} 
 
echo "</select>"; 
}