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...
WHERE products.styleCategory LIKE '%categories.id%'
... will (a) not work like you think it will, and (b) never scale well,
since it will always require a full table scan
rudy
http://r937.com/
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
