[Resolved] No duplicates

[Jon12345]

I have the following:

$result = mysql_query("SELECT * FROM products ORDER BY CategoryID");

How do I modify that to get rid of the duplicates in CategoryID?

e.g. I dont want a list saying red, red, red, blue, blue, yellow, yellow.

Rather, I want it to show red, blue, yellow.

Thanks,

Jon

[leatherback]

$result = mysql_query("SELECT distinct CategoryID FROM products ORDER BY CategoryID");

[Jon12345]

Worked a treat, thanks.

Jon