Multiple update query

[kouros91]

Hi. I would like to make a query with multiple fields update in a single query. But
that doesn't work
My code :

$myDb = JFactory::getDbo();
$myQuery = $myDb->getQuery(true);
$myQuery
   ->update('table_adhcont2')
   ->innerJoin('table_temp on table_temp.userid = table_adhcont2.id')
   ->set('table_adhcont2.nbjoursavtecheance = table_temp.nbjoursavtecheance'.' and '.'table_adhcont2.imagealertefinadhesion = table_temp.imagealertefinadhesion' );
$myDb->setQuery($myQuery);
// dump((string)$myQuery, 'update query');
$myDb->execute();

Thank you for help

 

[cheesegrits]

See "Updating a record" ...

https://docs.joomla.org/Inserting,_Updating_and_Removing_data_using_JDatabase

So you can either build an array for your set() statements, or you can use multiple chained set() ...

->set('foo = bar')
->set('foo2 = bar2')

-- hugh

 

[kouros91]

Thank you It Works