display list of categories and sub-categories

table contains categories:

jewellery

cards

toys

another table contains sub-categories:

jewellery, rings

jewellery, pendants

toys, cuddly

toys, vehicles

I have a show_products.cfm page which takes a paramenter, category

eg.

show_products.cfm?category=jewellery

is it possible to list all the categories and when you get to jewellery list it's sub-categories also ?

This topic has been closed for replies.

Inspiring

I'm trying to solve it like this, but its generating an error one query inside another

<li><span>>#getCategories.category#</span></li>

<li><span>#getSubCategories.name#</span></li>

</cfoutput>

</cfif>

</cfoutput>

do I need a single query with a LEFT JOIN ?

Sign up