hi
Iam doing a proj in php with mysql as the database.
Actually i want to Insert a value in a transaction table and get the max count of that table.
For this I have to lock the table.
But if that I lock the table and then insert it is not inserting even for the current thread of connection.
so please suggest me way to find the correct max count by using Lock method.
If that any other way of geting the max count please do tell me.
Thanx
with regards
kalyan
Iam doing a proj in php with mysql as the database.
Actually i want to Insert a value in a transaction table and get the max count of that table.
For this I have to lock the table.
But if that I lock the table and then insert it is not inserting even for the current thread of connection.
so please suggest me way to find the correct max count by using Lock method.
If that any other way of geting the max count please do tell me.
Thanx
with regards
kalyan