[perleo]

I have a huge number of rows in my mysql db.
from the column facility i want to be able to put those into a drop down list. one problem is that the several hundred words the same but i only need one of them. for example...the column looks like this

syslog
user
syslog
syslog
cron
auth
cron
auth
auth
mail
local7
syslog
local7

I want to be able to create a drop down list like this

syslog
auth
mail
local7
user
cron

Only having one of each item in it, no duplicates.How do i parse this in php?

[uprightdog]

I'd look into using GROUP BY in your SQL query

[darkfreak]

Hmm... I was left a bit unclear about this, but here's something:

SELECT DISTINCT columname FROM tablename ORDER BY columnname ASC

will select each value from the table column only once and order them alphabetically in growing order (ASC replaced by DESC would do the opposite).

Sorry if I understood wrong and told you just some basic stuff...

[MasQ]

Not sure if you helped him, but you sure made my day

[perleo]

Originally Posted by darkfreak

Hmm... I was left a bit unclear about this, but here's something:

SELECT DISTINCT columname FROM tablename ORDER BY columnname ASC

will select each value from the table column only once and order them alphabetically in growing order (ASC replaced by DESC would do the opposite).

Sorry if I understood wrong and told you just some basic stuff...

works like a treat, thanks very much!