How Can We Help?
After you performed an Insert statement use the insertid method to get the auto-incremented value from the last Insert statement
$db = $this->getDbo();
$query = $db->getQuery(true);
$query->clear();
$query->insert('#__database_table1');
$query->set("id=".(int)$id);
$db->setQuery($query);
$db->query();
//Now we get the last inserted id
$lastInsertId = $db->insertid();
echo $lastInsertId;Note in the above code we used $db->insertid(); to obtain the last inserted id.
