How to get the last insert id from $GLOBALS['db']-query?

Question

How to get the last insert id from $GLOBALS['db']->query after running an insert sql statement? If there a build up function for it? Thanks!!

Sugar crmm · Accepted Answer

You can create an New random ID using create_guid() before first insert and than use this ID in second insert as parent_id More Info Here: ht tp://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_6.5/Application_Framework/SugarBean/CRUD&hellip; and here HOWTO: Using the bean instead of SQL all the time. &laquo; Sugar Developer Blog &ndash; SugarCRM

How to get the last insert id from $GLOBALS['db']->query?