Page 1 of 1

INSERT and SELECT

Posted: Tue Aug 02, 2005 8:19 pm
by Todd_Z
I have an autoincrement and unique id num in a db, and when I insert a field, i want to have the query return the id for that row. Can i do that in a single sql?

Posted: Tue Aug 02, 2005 8:36 pm
by feyd
no, but the mysql functions can tell you what ID it set... mysql_insert_id