On 2/4/07, Rick Apichairuk <suppressed> 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
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.