View Full Version : Populate HTML Drop Down Box From MySQL Data

11-01-2012, 02:23 AM
Edit: Solved!

$query = "SELECT DISTINCT category FROM browse";


I have a piece of code that gets data from my MySQL Table and puts it into a drop down box. It works great. However I don't want it to duplicate rows.

For example some things in the table have the same category and at the moment it displays the category multiple times in the drop down box.

How can I avoid this?

Select a category: <select id="dropdown" name="cat">
include 'config.inc';
$query = "SELECT * FROM browse";
$result = mysql_query($query) or die (mysql_error());
while($row = mysql_fetch_array($result)) {

?><option><?php echo $row['category']; ?></option>