Need to get data for newly submitted record

[leinj]

Hi, got a question here.

I have a form that submits a record into a table in MySQL. I need to be able to add another form onto the processing/completion page so that the user can instantly add another record into a different table that references the first table.

My problem is that I don't know how to tell this page what the recordID (auto-increment field) is for the record to be referenced since it was just submitted on that page.

Is there a bit of code that will spit back the auto-increment number assigned during a query?

I can post some code up here if that would help this make more sense, just ask.

Thanks,

John

[barand]

See [man]mysql_insert_id[/man]

[leinj]

Thank you very much! That's exactly what I needed.