Link to home
Start Free TrialLog in
Avatar of XK8ER
XK8ERFlag for United States of America

asked on

mysql display unique using php

hello,
I have about 12,000 records inside mysql table and I would select everything and just display the "names" from a Column without duplicates.. how can I do this using php?
ASKER CERTIFIED SOLUTION
Avatar of Gary
Gary
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of XK8ER

ASKER

i dont know the names so how do I do that?
Then remove that part

SELECT UNIQUE column_name,other_columns FROM table

Open in new window

Avatar of XK8ER

ASKER

your code did not work.. but this works


SELECT DISTINCT (stockSymbol ) AS daStock FROM US500 ORDER BY daStock DESC  

Open in new window

Oops wrong database type.
Avatar of XK8ER

ASKER

I've requested that this question be deleted for the following reason:

found the answer myself