i am not testing this... just writing it here. and it is 2am !
SELECT shopping_cart.item_id, shopping_cart.subtotal, shopping_cart.quantity
FROM shopping_cart, orders WHERE shopping_cart.order_id = orders.order_id
AND orders.session_id = session_id() AND orders.customer_id = '$customer_id'
i guess u could give it a try.
just a simple 2 table join.
i may not have the fields and order in place but try it....
"Jonathan Villa" <[EMAIL PROTECTED]> wrote in message
> I can't figure this query out.
> I want to pull data from 2 tables but using a primary key from one.
> Here is what I think it should look like.
> SELECT item_id, subtotal, quantity from shopping_cart WHERE order_id =
> (SELECT order_id FROM orders WHERE session_id = session_id()) AND
> customer_id = $customer_id;
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php