MYSQL/PHP Dynamic Drop Downs

[spectsteve7]

I have a dropdown menu that is being populated by my database. Basicly I'm each record has a category that it's associated with. When my dropdown is populated it displays a category for every record.

Q: Is there a way to only have the category show up only once?

Here is my page: See the style dropdown

http://spectrumedia.com/clients/holtandbugbee/productshowroom/results.php?category=Picture%20Frames

My second question is I want to display on the same page all entries that have the same size using the dropdown menu. I'm not sure if it's to late or what but I can't figure it out.

Any help would be great.

Here is my dropdown code:

<form name="form2">
<strong>Select a style: </strong>
<select name="menu2" onChange="MM_jumpMenu('parent',this,0)">
<option value="#" selected>Choose one</option>
<?php while($row3=mysql_fetch_array($sql_result3)) { ?>
<option value="../productshowroom/results.php?category=<?php echo $row3["category"]; ?>"><?php echo $row3["category"]; ?></option>
<?php } ?>
</select>
<input type="button" name="Button1" value="Go" onClick="MM_jumpMenuGo('menu1','parent',0)">
</form>

[cgraz]

mysql has something called DISTINCT that should be what you're looking for here. I didn't see your query anywhere, but this should give you an idea

SELECT DISTINCT(categories), field2, field3 FROM your_table

[spectsteve7]

Here is my query. How do I work distinct into that?

$sql2="select * from profiles order by category ASC";
$sql_result2=mysql_query($sql2,$connection) or die("couldn't execute query");