listing data

[The_PHP_Newb]

How can I list data without duplicate items being listed.

Database Example:

abc
xyz
abc
xyz
def

I want the list to be displayed like this:

• abc
• def
• xyz

I can of course list data but I don't know how to remove duplicate entries. Can anyone help?

Thanks!
Jim

[LordShryku]

SELECT DISTINCT field
FROM table

[The_PHP_Newb]

EXCELLENT! thanks a bunch, this forum is the best!

[LordShryku]

Originally posted by The_PHP_Newb
this forum is the best!

I agree 🙂