how do i get a record id of last inserted record in interbase

[bloomoon]

problem with interbase. my 1st query looks like this:

$sql="INSERT INTO CLIENT (CLIENT_NAME, LAST_UPDATED) VALUES ('$clientname', '$date')";

my 2nd query looks like this:

$sql="INSERT INTO CLIENT_APPLICATION_VERSIONS (CLIENT_ID, APPLICATION_ID, VERSION_NUMBER) VALUES ('???, '$accounts','$lastid)";

the problem is finding out the value of CLIENT_ID in my second query (denoted by '???'). This must equal the CLIENT_ID assigned by a generator by the first query when I inserted a record into the CLIENT table.

how can I find out the value of ??? please

[ahundiak]

http://www.php.net/manual/en/function.mysql-insert-id.php

[bloomoon]

yes but this function is not available for interbase. no worries anyways ive solved it. many thanks!