[SOLVED] Help with $update = mysql_query

[chinclub]

I am trying to write a PHP script that will be run by cronjobs that will add interest to all of my members money, however, instead of adding the interest it just sets everyone's money at 0.  What am I doing wrong?

 

<?
include("header.php");

$interest_rate = 2 / 100;
$update = mysql_query("UPDATE `members` SET `bank` = 'bank + (bank*{$interest_rate})'");

	 	if($update) {
		 	print "<h2>Done!</h2>";
		}
		else {
		 	print mysql_error();
		} 

include("footer.php");?>

[trq]

Try...

 

mysql_query("UPDATE `members` SET `bank` = bank + (bank*{$interest_rate})");

[chinclub]

That did it!  Thanks!