Re: [PHP-DB] Re: MySQL Database Locking - needed?

2001-07-10 Thread Tom Peck
Thanks for the reply Manual. The updating IS done with one single query - but the problem is that if two people are editing the same car, the second update will overwrite the first. Not a huge problem - and the chance of it happening is almost nil - but there is still the possibility..

Re: [PHP-DB] Re: MySQL Database Locking - needed?

2001-07-10 Thread Raquel Rice
Tom Peck wrote: Thanks for the reply Manual. The updating IS done with one single query - but the problem is that if two people are editing the same car, the second update will overwrite the first. Not a huge problem - and the chance of it happening is almost nil - but there is still

Re: [PHP-DB] Re: MySQL Database Locking - needed?

2001-07-10 Thread Tom Peck
So what you mean is: If someone clicks on a car to edit, a txt file is written (maybe called the carID.txt). Then if someone else clicks on that car to edit it, it says that it is already being edited by someone else because the txt file exists? So what happens if that person who clicked