: Doing multiple updates
I have decided to implement the "soft-lock" schema below. I cannot use the
userID as the value for the lock. Is there any other unique number that can
be generated that I could use. I am thinking about using a session_ID in
PHP? Any suggestions/Comment
al Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 4:10 PM
To: Randy Johnson; [EMAIL PROTECTED]
Subject: RE: Doing multiple updates
Randy,
My recommendation (and there are probably many people who will disagree with
me) is to use a "soft-lock" sche
nson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 8:48 PM
To: [EMAIL PROTECTED]
Subject: Doing multiple updates
Hello,
I am creating a mock site that has a money balance that people can login
and pretend to pay money for stuff online via my site.
I am using php with mysql to im
use a soft lock
like you've described. I dunno.
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 9:10 PM
To: Randy Johnson; [EMAIL PROTECTED]
Subject: RE: Doing multiple updates
Randy,
My recommendation (and there are probably many
e for even
seeing the data and some (M$ SQL) used to lock whole tables to do a single
update. (sux big time)
HTH,
Cal
http://www.calevans.com
-Original Message-
From: Randy Johnson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 2:48 PM
To: [EMAIL PROTECTED]
Subject: Doing multip
t. The lock will not exist if it was never obtained by a call to
GET_LOCK() or if it already has been released.
Mark.
-Original Message-
From: Randy Johnson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 8:48 PM
To: [EMAIL PROTECTED]
Subject: Doing multiple updates
H
Hello,
I am creating a mock site that has a money balance that people can login
and pretend to pay money for stuff online via my site.
I am using php with mysql to implement this.
How do I make sure that a balance for a particular account is (locked) so
only 1 spend for that account can happen
