echo'ing last ID PearDB

[crawfd]

I have an sql statement below but after several attempts at echo'ing the last id have failed. the 'completed' field is the auto increment field and the field I'd like to echo after the query runs.

$query = "INSERT INTO {$this->CONF['db_tbl_prefix']}completed_surveys (uid, sid) VALUES ({$_SESSION['priv'][$survey['sid']]['uid']},{$survey['sid']})";
$rs = $this->db->Execute($query);

[NogDog]

You'll probably want to look into using PEAR DB's "sequences" for generating ID's (one of the prices you pay for a non-DBMS-specific interface).