Update function

[sharezack]

Hello friends

i am having a problem in my update function.

I have two tables

buyselldata table and autozack_signal table

buyselldata bsignal coloum has to be updated with Close_Price in autozack_signal table if macd_buy in autozack_signal is 1

common field in both tables are Script_Name

"Update buyselldata b
set b.buy = a.Close_Price
where exists(select Close_Price from autozack_signal a
where a.script_Name = b.script_Name
and a.macd_buy=1)";

i am getting -1 for mysql_error()

pls help me

[Barand]

DISCLAIMER: Untested, so backup tables first

UPDATE buyselldata b , autozack_signal a
SET b.buy = a.Close_Price
WHERE a.script_Name = b.script_Name
AND a.macd_buy=1