this makes sense -- prodcatmatch is a many-to-many relationship table that joins products to categories
======== My categories table has several 'types'. 2 = size 3 = Country 5 = category description (fashon tshirt, vneck etc) so I'm having to puick out category AND size so that's why I'm refering to it twice. Perhaps I should have had a size table and a description table etc.. but I thought it'd be quicker to keep them all in one table? would you like my table structure dump again? ========
inner join categories as parent on parent.id = stock.size and parent.gender = '1' and parent.type = '2'
this doesn't make sense you're going from product to prodcatmatch to categories, so the join condition here should logically involve a column from the prodcatmatch table being equal to the category id but you're joining a category id to a stock size??? ======== I'm refering to stock size to only show items that are in stock. the category 'Mens small' for exampe is ID 4, so category 4 is in the stock table many times (once per product) there was a condition 'stock.count > 0' but I can't see it on this mail. ========
inner join categories as child on child.id = prodcatmatch.category and child.type = '5'
this sort of makes sense, except why are you joining to two different rows of the categories table? ======== See above, I've got one big categories table for all items ======== i can't help you sort this out unless you know why you're doing that
inner join brands on brands.id = products.brand
that makes sense p.s. would you kindly, please, pretty please, i beg you, trim your replies, and please stop top-posting ======== Don;t mean to. Gmail keeps forcing it! I'll repost each time... that shoudl fix it!??? ======== thanks ____ � 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.
