In article <[EMAIL PROTECTED]>, Torsten Roehr wrote:
> Add an int field oca to your table. Increment this value on every update.
> When someone edits a row, read the value and put it into a hidden field.
> Then on update check for condition WHERE oca = $ocaFromHiddenField AND id =
> $id etc. Check
"Michael Gale" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello,
>
> I have a web app that uses a mysql database, now lots of INSETS and
> UPDATES are done on a daily bases. Now I do not want to start locking
> tables. For the INSERTS it is just a plain insert with a auto increm
Hi.
Please stop cross-posting and use the appropriate forum.
On Wed, Nov 21, 2001 at 03:27:23PM -0700, [EMAIL PROTECTED] wrote:
>
> (PHP-DB folks, ignore this top question - unless you want to answer)
>
> Which type of DB/Table provides table locking while a process is
> altering data?
Hi Ashley,
Insert records into a table with a primary key that you define,
not an autoincrement field. When 2 people try to insert a record
with the same primary key, one will fail, the other will succeed.
The one that fails will poll the database until the other record
successfully completes th
