Hi all...
I've not been here for AGES... but I hope many of you trusted clever
people are still out there... I need help! ;-p
I'm building a shop for a client.
I've got 3 tables I'm trying to talk to.
products
stock
categories
- Each product can be flagged with any numebr of cateogories using
I'm building a shop for a client.
this would be a good time to change the table design;o)
never put a comma-delimited string of ids into a single field
you need another table, ProductCategories, to contain two columns, productid
and categoryid
the reason? because sql like this...
Quoting r937 [EMAIL PROTECTED]:
I'm building a shop for a client.
this would be a good time to change the table design;o)
never put a comma-delimited string of ids into a single field
you need another table, ProductCategories, to contain two columns,
productid and categoryid
the