Re: My Project
| From: | George B | Date: | Tue, 19 Jul 2005 23:05:06 +0000 |
| Subject: | Re: My Project | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-219009@lists.php.net to get a copy of this message | ||
Jay Blanchard wrote:
[snip] $money -= 10; saves some chars ;) [/snip] This actually requires two trips to the database, once to get $money and once to update $money. Do it in the query instead...once..... $sqlUpdate = "UPDATEThis is the table: CREATE TABLEmyDatabase.myTableSETmyMoney= (myMoney-10) WHEREmyCharacter=characterName"; $doUpdate = mysql_query($sqlUpdate, $myConnection); saves lots of characters ;) Hey, Look I made a new database just for this money testing stuff.
money (
money varchar(255) NOT NULL default ''
) TYPE=MyISAM;
Now, I use this code
$sqlUpdate = "UPDATE myDatabase.myTable SET myMoney =
(myMoney-10) WHERE myCharacter = characterName ";
$doUpdate = mysql_query($sqlUpdate, $myConnection);
And it should work, And it gives no error but it is not writing anything into the database.