22.01.2012, 15:13
First query:
Second one:
PHP код:
// Sets voltcount to voltcount - 1 where volt = 1
UPDATE `TABLE_NAME` SET `voltcount` = `voltcount` - 1 WHERE `volt` = 1
PHP код:
// Sets volt to 0 where voltcount <= 0
UPDATE `TABLE_NAME` SET `volt` = 0 WHERE `voltcount` <= 0