interest rates

[grlayouts]

ok i have my own online game, when people bank it updates the database ie bank=bank+(ammount)

I want it up update by 0.03 percent or so every hour for interest.

the script i have is

[code]
<?
include('config.php');
error_reporting(E_ALL) ; ini_set('display_errors', 1);

mysql_query('UPDATE `players` SET `BANK` = `BANK` + (`BANK` * '.rand(1.01, 1.02).'), `interest` = `interest` (`bank` * '.rand(1.01, 1.02).')');
?>
[/code]

but its not working.. any ideas?

[rantsh]

can you provide an example printout of your query? ??? 

[grlayouts]

it completes but doesnt not work.

[Balmung-San]

Could be me, but it seems like you're missing an operator:

[code]`interest` = `interest` (`bank` * '.rand(1.01, 1.02).')[/code]

Shouldn't that be:

[code]`interest` = `interest` + (`bank` * '.rand(1.01, 1.02).')[/code]

[paul2463]

yes you are missing a maths function  in your query

look at you your query, especially the part about interest, for maths to work it needs operators ( * / = etc)

interest = interest ( !!!missing operator!!!)  (bank * rand)

[grlayouts]

yeah i see that.. but even the bank one is not working..

[paul2463]

ok then, try setting the rand(1.01, 1.02) as a variable first

[code]
<?php
include('config.php');
error_reporting(E_ALL) ; ini_set('display_errors', 1);
$interest = rand(1.01, 1.02);
mysql_query("UPDATE `players` SET `BANK` = `BANK` + (`BANK` * '$interest'), `interest` = `interest` + (`BANK` * '$interest')") or die ("Cannot Update Table". mysql_error());
?>
[/code]

[Jessica]

Off topic, but why are you giving random amount of interest? If my bank did that, I'd get kind of annoyed.

[grlayouts]

i have no idea.. i did have a good reason but now no idea.. :D

[Jessica]

You could do it on a scale. The more money they have, the more interest they get. So 1-1000 gets 1%, 1000-5000 gets 1.5%, etc.

[grlayouts]

i could if i knew how.. :)