Forums

Accessing the database directly

Permalink
For my custom block, I am accessing my own tables in the database using C5's extraction layer via $db = Loader::db();
Is there a built-in function to give me the ID of the last acted-on (esp inserted) record?
hockeyshooter
 
hockeyshooter replied on at Permalink Reply
hockeyshooter
I had hoped that the result of
$r = $db->query($q);
...would contain something of use. $r is an associative array, but sadly no elements give me the affected record ID.
Remo replied on at Permalink Best Answer Reply
Remo
C5 uses Adodb, check their documentation and you'll find something like this:

$db->Insert_ID();