[RESOLVED] Query a Database & Display Results in a Drop Down Menu

[transfield]

Hello,
I'd like to query a Mysql database & display the results in a drop down menu without any duplicates. I've attached a screen shot to show you what I mean. I know how to connect to the Mysql database so we can skip that part.

Thanks a lot for your guidance.

[bogu]

Try to read something from here: http://phpbuilder.com/board/showthread.php?t=10245251

[crangic]

I use somehting like this

	$sql = mysql_query("SELECT DISTINCT id, name FROM products");

while($row = mysql_fetch_assoc($sql))
{ 
	$dd .= "<option value='{$row['id']}'>{$row['name']}</option>";
}

Then just echo out $dd in your html.

<select name="products" style="width: 222px;">
<? echo $dd; ?>
</select>

[transfield]

Thank you Bogu for pointing me in the appropriate direction. Much appreciated.
Thank you Crangic for your generosity in sharing your knowledge. Very much appreciated.