Re: LEFTJOIN ???
Posted by:
Tony Mole
Date: December 13, 2017 08:45AM
Final post... in case anyone else needs something similar, this is the code which finally works in both PHPMyAdmin and from PHP;
PHPMyAdmin;
UPDATE stock_price SET `Qty`=(SELECT `Qty` FROM stock_total WHERE stock_price.Sup_Pt_Nr = stock_total.Sup_Pt_Nr)
PHP Script;
mysql_query ( "UPDATE stock_price SET `Qty`=(SELECT `Qty` FROM stock_total WHERE stock_price.Sup_Pt_Nr = stock_total.Sup_Pt_Nr)" );
Many thanks
Tony
Subject
Written By
Posted
December 12, 2017 11:41AM
December 12, 2017 12:04PM
December 12, 2017 03:39PM
December 12, 2017 05:21PM
December 13, 2017 03:04AM
December 13, 2017 03:29AM
December 13, 2017 08:38AM
Re: LEFTJOIN ???
December 13, 2017 08:45AM
December 13, 2017 10:34AM
December 15, 2017 09:57AM
December 16, 2017 04:44AM
December 19, 2017 10:17AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.