|
|
Posted by NC on 10/09/05 21:58
google@charliefortune.com wrote:
>
> 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' ?
Yes. Your links table could have three fields: product, category,
and subcategory. All three would be indexed.
Cheers,
NC
Navigation:
[Reply to this message]
|