[RESOLVED] Shopping Cart Reading Multiple Tables

[tripwire8]

I'm putting together a shopping cart and have run into a problem. I have my cart table storing the users chosen shopping cart info, then multiple tables storing the details of each category of products. For example books, music , dvds etc. What I can't figure out is if it is possible to call multiple product records in my join statement. Can I loop through a list of my product categories somehow or how can I do this?

$sql= "select * from cart inner join $cat on cart.itemId = $cat.$catId where cart.cookieId = '" . GetCartId() . "' order by $cat.title asc";

[bradgrafelman]

Well, you might be able to do this in two separate queries, i.e. pull the cart data into PHP and figure out what tables need to be selected, or possibly use MySQL's CASE statement in a stored routine (or try to use it inline with your current query - this describes using CASE inside a query).

I'm not SQL guru, just throwing out possibilities here... :/

[tripwire8]

Thanks, I ended up using the two separate queries method. Then from the results of the first query I used the array_unique function to obtain non duplicate results of my categories.