Query Help.

[seany123]

okay so im making a game, and because my current host doesnt allow Cron jobs... ive had to create my own file which when called it will update my database.

 

what im wanting is for a code which will make it so:

 

$player-> will + 5 but not go higher than $player->maxnerve.

 

the reason i cant give maxnerve a value is because it can change depending on each player.

[Mchl]

UPDATE players SET will = will + 5 WHERE will < maxnerve

[seany123]

i mean awake and maxawake instead of nerve... but it doesnt matter too much.

 

would this work?

 

if (awake +5 >= maxawake){

$query = $db->execute("update `players` set awake = maxawake WHERE `id`=?", array($player->id));

}

 

if (awake +5 < maxawake){

$query = $db->execute("update `players` set awake + 5 WHERE `id`=?",

array($player->id));

}

 

EDIT: it didnt work.... now going to try your way.

[seany123]

tried UPDATE players SET will = will + 5 WHERE will < maxnerve...

 

didn't work though.

[Mchl]

Did you get any error messages?

[Maq]

Can you please:

 

1) echo out $query.

2) add or die(mysql_error()) to the end of your queries.

3) add this to the top of your script:

 

ini_set ("display_errors", "1");
error_reporting(E_ALL);

 

Not sure but I think you also need to do:

 

if((awake+5) >= maxawake) {