Posted by Feudalac! on 10/24/05 13:20

I have to insert a value into a table and with the new ID i have to
update some other tables.

is there a way to do it like:
insert into table (fields) values(...) and return id of new record

update table set field=id of new record where id=number


for now i
insert into table
read last record from table (order by id desc limit 1)
and then undate other tables with the id given...

something to reduce the number of queryes...


thanks

[Back to original message]