On 2/4/07, Rick Apichairuk <[EMAIL PROTECTED]> wrote:
When the user clicks submit, the data in the form is submitted to your program which will then lock the table for write and insert the record. Your program then selects the last insert id and unlocks the table so others can write to it.
Just to be clear, you don't need to explicitly lock a table if you're using AUTO_INCREMENT for your IDs. MySQL handles the locks automatically when you do your INSERT. - Perrin