XK8ER
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Then remove that part
SELECT UNIQUE column_name,other_columns FROM table
ASKER
your code did not work.. but this works
SELECT DISTINCT (stockSymbol ) AS daStock FROM US500 ORDER BY daStock DESC
Oops wrong database type.
ASKER
I've requested that this question be deleted for the following reason:
found the answer myself
found the answer myself
ASKER