Question on UPDATE
Posted: Thu Jan 12, 2006 2:06 pm
Hi all..
With this code, it's updating `LastItem`, but not `ItemUsed`. Is that becuse I have one of the conditions as `LastItem` = 1. And when that changes to 0, it's no longer true?
Thanks
David
Code: Select all
"UPDATE `ItemInformation` SET `LastItem` = 0, `ItemUsed` = 0 WHERE `GameNumber` = $row[0] AND `TeamNumber` = $row[1] AND `LastItem` = 1";With this code, it's updating `LastItem`, but not `ItemUsed`. Is that becuse I have one of the conditions as `LastItem` = 1. And when that changes to 0, it's no longer true?
Thanks
David