how can I translate SQL code into something that Joomla will take?

by Pablo Castelo   Last Updated February 12, 2018 17:10 PM

friends at, I am in the same case discussed on , this is, I need to copy the value of a column from tableA to tableB based on a common column in each table. I have used the suggested code inside of phpmyAdmin, and it works perfectly. UPDATE TableB SET TableB.value = ( SELECT TableA.value FROM TableA WHERE = ); My problem is that I have been unable to translate this into something that I can use inside of my mod_xxx.php file. On the same stackoverflow page, there is a suggested code that uses mysql_query and supposedly works, but Joomla doesn´t accept it. I know that any code has to be translated to Joomla's coding standards but I have spent three complete days trying it with no success. As you may guess, I am not knowledgeable on PHP coding, so I am in serious need of your help, please. My question is how can I translate the upper code into something that Joomla will take? Thank you very much in advance for any piece of advice.

Tags : php mysql

Related Questions

Database query outputting twice

Updated February 03, 2019 02:10 AM

Display a Value from a Specific DB Field

Updated April 30, 2016 08:04 AM

Delete users from Joomla V2.5

Updated November 08, 2016 08:04 AM