Need help with insert in multiple tables with last_insert_id

[chanw1]

Hi

I need some help with inserting into multiple tables.

I have a form that gathers a user info.

I need help with a sql statement that does the following

1. Inserts Form Values into Users Table
2. Requery Last Inserted ID
3. Insert into the last_insert_id into anothe table.

Any help would be appreciated.

Thanks

[hostcord]

Is this to track the most recently registered users. Could you elaborate more on what you are doing?