$db insert, how to get last inserted id?

[jomlary]

My php/sql query is so:

Code: Select all

$db = JFactory::getDbo();
    $insertProjectUser = 'INSERT INTO #__pmanager_user (user_cms_id, user_email, user_created_ip) VALUES (' . $user->id . ', "' . $user->email . '", "' . $_SERVER['REMOTE_ADDR'] . '")';
    $db->setQuery($insertProjectUser );
    $db->query();
$addressID = $db->insertid();

If i do: echo $addressID; i get empty string, not last inserted id, how can i get right result? If i show in database then insert was succesfully.

I need last inserted id because of a new query for another table.

[itoctopus]

This problem has nothing to do with Joomla, but it might be that you don't have persistent connections at your database level.

In any case, insertid() (which uses the last_insert_id ) is dangerous, because if you have a very active site, it might return a different a different ID than the one that you want. You should run a query and get the ID of the row that you just inserted instead of relying on that (unreliable) function.