HELP WITH UPDATE MYSQL AND + AND -

[nauir]

$n=$bank[Money]+12000;
$d=$bank[Money]+20000;


mysql_query("UPDATE player SET Money=Money='$n' where id='$id' AND Status='normal'")or die(mysql_error());
mysql_query("UPDATE player SET Money=Money='$n' where id='$id' AND Status='Normal'")or die(mysql_error());
mysql_query("UPDATE player SET Money= Money='$d' where id='$id' AND Status='Diamond'")or die(mysql_error());
mysql_query("UPDATE player SET Money= Money='$d' where id='$id' AND Status='diamond'")or die(mysql_error());
mysql_query("UPDATE player SET Money= Money='$d' where id='$id' AND Status='Mod'")or die(mysql_error());
mysql_query("UPDATE player SET Money= Money='$d' where id='$id' AND Status='mod'")or die(mysql_error());

 

Its all odd because I've tried a hundred things. I give up. Give me super odd php scrict mysql odd version server asnwers..?

[Mchl]

You did not say what your problem is.

 

 

 

Change

SET Money=Money='$n'

 

to

SET Money=Money+$n

 

that's for start