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 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
I concur, add another table, it will make life easier. :) Matt -- Matthew Macdonald-Wallace [EMAIL PROTECTED] "Sed quis custodiet ipsos custodies?" ____ 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.
