passing values from 2 tables to another

[itworks]

i have this query:

$sql = "INSERT INTO orders(email, cod, qty, type, model, price)
SELECT email, cod, qty, type, model, price FROM cart
WHERE email='$login_user'";

this stores into ORDERS the values that i have in those columns in CART, but besides this i would like to store in these columns in ORDERS (address, zip_code, state) the values in the table USERS (address, zip_code, state).

i've tried everything but the problem is that i can't get the syntax right.

how can i insert into a table values by selecting them from 2 other tables??

thanks in advance!

[eoghain]

You need to do a join in your select, so you are going to need a field that you can join on. I'm going to assume that your email field exists in both tables:

INSERT INTO orders(email, cod, qty, type, model, price, address, zip_code, state)
SELECT c.email, c.cod, c.qty, c.type, c.model, c.price, u.address, u.zip_code, u.state
  FROM cart c, users u
 WHERE c.email = u.email
   AND c.email = '$login_user';

[itworks]

thanks a lot, it works and it's like hot pancakes in a cold day!!!
😃