Concurrent transactions cause me a lot of problem while updating the value in the same table. Is that right to use the lock function from mysql? But how do I implement with php coding?
Best, Anakapon
Just run the lock query. Also try using InnoDB tables from MySQL, which allow transactional row-level locking.