Eliminating Doubles in SQL

[Marsbar24u]

I am developing a ecommerce website. In dreamweaver I have the product
categories from the database display as links, my problem is that there is more
then 1 product with the same category name and so there are multiple same name
categories showing up as links. How do i remove multiples?

[webshorts]

Hi Marsha, You could use a SELECT DISTINCT query. The DISTINCT keyword says
'get all unique values'. So if you did this: SELECT DISTINCT categories FROM
products That would give you only the unique categories in the products table.
If you had two products in the 'Bob' category, then bob would only be returned
once. Hope that helps, Daniel Short

[Marsbar24u]

Awesome, that worked

[Michael Fesser]

.oO(Marsbar24u)

>I am developing a ecommerce website. In dreamweaver I have the product
>categories from the database display as links, my problem is that there is more
>then 1 product with the same category name and so there are multiple same name
>categories showing up as links. How do i remove multiples?

Why not split it and use one table for the categories and another for
the products?

Micha