to make a drop down box from a database<?phpecho "<select name='mydropdown'>\n"."<option>Default Option</option>\n";$query = "SELECT * FROM table WHERE whatever = 'something'";$result = mysql_query($query);while($row = mysql_fetch_assoc($result)){echo "<option>".$row["filedname"]."</option>\n";}echo "</select>\n";?>I hope this helps in some way