CodingForums.com - Populate HTML Drop Down Box From MySQL Data

Edit: Solved!

PHP Code:


		
			
$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?

PHP Code:


		
			

Select a category: <select id="dropdown" name="cat">
  <?php
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>
<?php
}
?>
</select>