PHP Lock Application??

[Ik]

Hi,

Is there a way to lock the application similar to Application.Lock in ASP.NET?

The reason is that I have an insert query that takes place in one of my PHP pages, and I want to get the auto ID from that record once the insert query takes place.

Or maybe there is a way to do that in one query? something like sending the ID back to the query once the record is inserted?

Thanks

 

[Eric]

PHP: mysql_insert_id - Manual

MySQL :: MySQL 5.0 Reference Manual :: 12.4.5 LOCK TABLES and UNLOCK TABLES Syntax

 

[Ik]

PHP: mysql_insert_id - Manual

MySQL :: MySQL 5.0 Reference Manual :: 12.4.5 LOCK TABLES and UNLOCK TABLES Syntax

Perfect

 

[Kate]

If you have mySQL 5 you could also use stored procedures, transactions, the works