mysql call

[Anon]

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?

[[deleted]]

There are no 'different selection criteria'.
The only selection criteria you have are:
- the sessionid field in the cart table must contain $PHPSESSID
- the productid in the products table must be the same as the productid in the cart table.

In MySQL:

$query = "SELECT * FROM cart, product
WHERE cart.productid = product.id
AND cart.sessionid = \"".$PHPSESSID."\"";

Read your local SQL manual about the JOIN statement.