MYSQL Update not Working

[Monk3h]

if ($step == upgrade) {

if ($stat[bank] < $bankmin) {

Print "You do not have the required funds in your account to Upgrade! Please transfer the required funds!";

}else{

mysql_query("update players set bankaccount=$newbank[name] where id=$stat[id]");

Print "You have successfully upgraded your account to our $newbank[name]";

}}

 

Can anyone tell me why this isnt working? Its displaying the text when i upgrade saying iv upgraded. But it dosnt  change the bankaccount feild in Players to the new Bank account. :s

[moselkady]

 

You should enclose array elements in braces if you use them within a string. Try changing your sql to the following and see how it goes:

 

mysql_query("update players set bankaccount={$newbank['name']} where id={$stat['id']}");

 

 

[Monk3h]

Done.. Still not Working.

[hitman6003]

Whenever you are having problems with a query there should always be two things you do before anything else...

 

1) echo out your query...

$query = "update players set bankaccount=$newbank[name] where id=$stat[id]";
echo $query;
mysql_query($query);

 

2) show the mysql error(s)...

$query = "update players set bankaccount=$newbank[name] where id=$stat[id]";
echo $query;
mysql_query($query) or die(mysql_error());

[Monk3h]

update players set bankaccount=Bronze Account where id=2You have successfully upgraded your account to our Bronze Account

 

 

 

So that should work. Thats exactly what i want it to do.. WTF!?

[Monk3h]

Could it have somthing to do with the account name having a spcae in it? Do i need to use a diferent Query?

[hitman6003]

A string must be quoted in an sql query...

 

bankaccount='Bronze Account'

[MadTechie]

try

$query = "update players set bankaccount='{$newbank['name']}' where id={$stat['id']}";
mysql_query($query) or die($query.mysql_error());

[Monk3h]

Thanks guys, i added in the '/' and it works now.  XD