PHP CALL 2 TABLES FROM ONE QUERY PLEASE HELP!

[l!m!t]

Hello, Hopefully someone can help me I have been at this for hours. I am trying to call two tables in one mysql query.

(see below )

$limit1 = "update " . CUSTOMERS . " set member_level = '10' [b]where orders_status_id =7 ";[/b]

order_status is located in a table called [b]ORDERS [/b]I cant figure out how to get that in the query. I have tried a Join command and still wont work. Everything else seems to work in basically just cant find "order_status", which is located in a table called ORDERS.

Any help would be very much appreocated!

[redarrow]

This would set member_level to 10 and orders to 10 with the order status of 7
[code]

$query ="update customers set members_level='10' , orders='10' where order_status='7' ";

[/code]

[l!m!t]

Hi thanks for the reply.

Order is actually a seperate table

(eg The formatting is probably not right, but is what I am trying to do.

[code]$limit1 = "update " . CUSTOMERS . " set member_level = '10'  where " . TABLE_ORDERS . "  orders_status_id =7 ";[/code]

I want it to only update where the order_status_id =7 , the only thing I cant figure out is how to query the ORDERS table in the same call.

[Orio]

Can you explain again?
You want to set member_level in CUSTOMERS table to 10 if that member has order_status_id set to 7 in the table called TABLE_ORDERS?

I [i]think[/i] this how it's done, but I really not sure-
"UPDATE ".CUSTOMERS." SET member_level = '10' WHERE member IN (SELECT member FROM ".TABLE_ORDERS." WHERE orders_status_id = '7')"

Like I said, I am not sure.

Orio.

[redarrow]

if what orio has posted is correct please let us no as i am learning mysql heavly and i have never seen that sql statement before let me no cheers.

intresting nice code orio.