Tony Crockford wrote:
get a numeric value from a MySQL table, do a calculation, then on another PHPpage update the numeric value in the table.
what I don't want is anyone else getting the same number from the table before I've updated it.
what PHP would you use to do this?
LOCK TABLES will not work because the lock is released when the first page is finished. You could use a file that will you will use as a lock, but this could lock your table for minutes and eventualy, if the user desides not to take any action, forever. I would suggest to use a temporary table to hold taken numbers.
Oh, okay.
is there a way I can get a number and increment it all in one query then?
TIA
Tony
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
