LAST_INSERT_ID()

[Anon]

I need help with LAST_INSERT_ID().

I have a mysql table with about 50 columns.

Data is added to the columns in 5 steps.

After the first INSERT statement, the remaining columns are filled using UPDATE.

After the first INSERT, I need LAST_INSERT_ID() to use in WHERE clause for subsequent data inputs.

My problem is that, after each of the 5 steps, the php script is exited, and called again to UPDATE table.

Will LAST_INSERT_ID() be available, even after a script is exited, and then called again?

Sorry for the long explanation.

Richie.

[fitzbean]

Just save the last_insert_id to a variable before you begin the next script.

[Anon]

You mean put it in a cookie? I'd rather not set a cookie if I don't have to, since I think I'm approaching the 20 cookies limit 🙂