Locking mysql tables with PHP
| From: | Tony Crockford | Date: | Tue, 25 Nov 2003 12:18:06 +0000 |
| Subject: | Locking mysql tables with PHP | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-170868@lists.php.net to get a copy of this message | ||
Hi
bit confused!
here's what I want to do:
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?
Sorry for what is probably a really basic question - I did look at the MySQL manual, but I'm not sure how exactly to issue an SQL query LOCK TABLES using PHP.
TIA
Tony