Posted by google on 10/09/05 17:38

Thank you both, I now have products, categories and subcategories
tables.

As I understand you, NC, there is a link table with an id corresponding
to the id's in the products table, and each entry has, say, 3 fields
with subcategory id's ? Then when I SELECT items subcategorised as
'vintage', I do a JOINed SELECT using 'links' and 'products' ?

[Back to original message]