PDA

View Full Version : Update multiple fields at same time to different tables


el.severo
2-8-09, 11:25 AM
Hi there,

I`m trying to perform an multiple update in the same time using J 1.5

$_CB_database->setQuery( "UPDATE #__comprofiler SET avatar = " . $_CB_database->Quote( 'gallery/' . $newAvatar )
. ", avatarapproved=1, lastupdatedate = " . $_CB_database->Quote( date('Y-m-d H:i:s') )
. " WHERE id = " . (int) $row->id);
$_CB_database->setQuery( "UPDATE #__mycom SET avatar = " . $_CB_database->Quote( 'gallery/' . $newAvatar )
. " WHERE user_id = " . (int) $row->id);

Right now it performs only to the second table #__mycom [ jos_mycom ].

Please help & Thank you!