I might be at the tail end of the thread, but what's wrong with an SP that
returns the ID. We do it all the time...

e.g.

create procedure INSERT_DATA(A INTEGER,B INTEGER,C VARCHAR(10))
returns (PK INTEGER)
as
begin
PK = GEN_ID(Generator,1);

insert into MY_TABLE (COL_PK,COL_A,COL_B,COL_C) values (:PK,:A,:B,:C);
end

I am quite sure you can execute a SP from PHP. We do it from ASP.

HTH

L.J. van Alphen

L.J. van Alphen
Director
Basix Automation

E-mail: lja@...
WWW: http://www.basix.co.za
Tel: (+27) (0)21-409 7018


P.O. Box 6330
Roggebaai
8012
Cape Town
South Africa