...

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



penny94
11-01-2012, 01: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">
<?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>



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum