Interesting. I'm following the documentation at http://pear.php.net/manual/en/package.database.mdb2.intro-sequences.php Here's my code: $sql = new SQL(); $sql->connect(DSN_METNET3_MY_EDIT); $qry = "insert into List(lstName, lstNotes, UserName) values ($name, $notes, $user)"; $sql->query($qry); return $sql->lastInsertID("List"); I'm now getting the following error message: Call to undefined method SQL::lastInsertID() Any further clues? Yves ------ Original Message ------ Received: Mon, 08 Sep 2008 01:29:42 PM CDT From: "Evert Lammerts" <evert.lammerts@xxxxxxxxx> To: "YVES SUCAET" <yves.sucaet@xxxxxxx>Cc: php-db@xxxxxxxxxxxxx Subject: Re: Getting started with MDB2 > * mysql_last_insert_id() getAfterId() http://pear.php.net/reference/LiveUser_Admin-0.3.3/LiveUser_Admin/LiveUser_Admin_Storage_MDB2.html#methodgetAfterId > * mysql_real_escape_string() escape() http://pear.php.net/package/MDB2/docs/latest/MDB2/MDB2_Driver_Common.html#methodescape -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php