Posted by George B on 07/20/05 02:05

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 = "UPDATE `myDatabase`.`myTable` SET `myMoney` =
> (`myMoney`-10) WHERE `myCharacter` = `characterName` ";
> $doUpdate = mysql_query($sqlUpdate, $myConnection);
>
> saves lots of characters ;)
Hey, Look I made a new database just for this money testing stuff.
This is the table:

CREATE TABLE `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.

• Next in forum: Mail Function
• Prev in forum: PHP is occasionally seg faulting
• Thread view: Re: [PHP] My Project

[Reply to this message]