[thelist] [MySQL] return values from query

[Paul Bennett]

Is there a way to return a field value from an insert query? Instead of
(1) inserting a new record and then (2) a select to get the match of the
new record and get the row id from the query (auto increment, primary
key), is there a way I can INSERT the new record and get mysql to tell
me the row_id value without querying a second time?

--
Paul Bennett
Internet Developer
Teltest Electronic Design
--------------------------
Phone : 64 4 237 0767
Web : http://www.teltest.com
Wap : http://wap.teltest.com
Email : paul at teltest.com
--------------------------