sounds like a simple question but i cant figure it out...
i have one table that holds cart information and another that holds product info. because i dont want redundant info, i have contained all the product info in the product table and only the product id in the cart. i want to select all the data in the cart WHERE sessionid = $PHPSESSID, AND the associated data from the product table. i know how to select data from multiple tables, but not when differant selection criteria apply. any thoughts?
i have one table that holds cart information and another that holds product info. because i dont want redundant info, i have contained all the product info in the product table and only the product id in the cart. i want to select all the data in the cart WHERE sessionid = $PHPSESSID, AND the associated data from the product table. i know how to select data from multiple tables, but not when differant selection criteria apply. any thoughts?