Drop down menu from mysql..

[jebster]

Ok, I can't quite figure this one out in my head, bad day I guess.. :o

I have a database which is a list of sites, it contains fields for site_id, site_name, site_url, site_type, site_added. I want to make a drop down menu containing each different type of site(site type) in it, but do not want it to list every site type entry just once for every different one. Like if I had three sites that are "Search Engine" I would want it to only show search engine once! Can anyone help me out? Thanks! 🙂

[OhLordy]

<select name=types><?
$sql="SELECT DISTINCT site_type FROM sites";
$result=mysql_query($sql) or die(mysql_error());
while($row=mysql_fetch_array($result)) {
?>
<option value=<?=$row['site_type']?>>
<?=$row['site_type']?>
</option>
<?
}
?>

HTH
Rob

[niroshan]

hi,
try this SQL query

select distinct site_type from <database name>;

regards,
niroshan

[jebster]

Sweet, thanks both of ya! 😃