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!
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!