[RESOLVED] How to retreive Auto number value for record just submitted?

[Sando]

Hello.

I'm designing a ticket booking system (in PHP + MySQL obv.) and my current plan is to have two, one for applications for tickets (identifying the booker, payment deadlines etc.) and another with the actual tickets.

I'd like to be able to write the data to the applications database, which will cause a new "applicationID" to be created as the record number are auto incremeneted, then retrieve this new applicationID to write into the tickets.

How would I achieve this?

Thanks.

[Piranha]

Use mysql_insert_id to get the id. Then use that number in the second insert (after checking that it is ok).

[Sando]

Thanks