Hey

I'm having some problems with categories and subcategories.

Basically I want to assign pages to either a category or subcategory.

For example:

Main Category
- Sub Category 1
-- Page 1
-- Page 2
- Sub Category 2
-- Page 1
-- Page 2

Another Category
- Sub Category 1
-- Page 1
-- Page 2
- Sub Category 2
-- Page 1
-- Page 2

I've got a categories table with columns categoryid, categoryname, parentid, where parentid is the main category.

In my pages table I have categoryid (the category the page belongs to).

The problem I am having is the mysql query and actually outputting the menu like I have added above.

Could anyone help me do this?