NYCPHP Meetup

[tedd]

At 9:32 AM -0400 6/30/08, Allen Shaw wrote:
>
>
>You all have any thoughts?

- Allen:

One word -- transactions.

http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-transactions.html

The transaction scheme is one that solves the problems you address. 
The theory is simply a record doesn't get updated unless it's certain 
that the process will happen.

Here's a tutorial on it:

http://www.devshed.com/c/a/MySQL/Using-Transactions-In-MySQL-Part-1/

Cheers,

tedd

-- 
-------
http://sperling.com  http://ancientstones.com  http://earthstones.com