Menu
in my table i have details about each product and one of the fields is for category.
so each item has a category given to it, ie tees, hoodies, shirts etc etc
i used the following code to go through and list all categories in table:
[CODE]
SELECT tblproducts.category
FROM tblproducts
i’m using this to build a menu for the site. but at the moment it lists it like this:
tees
tees
tees
hoodies
hoodies
shirt
and so on.
how can i restrict it to only show each category once?
do i need a seperate table with just categories in or can i limit each one?