[nezo2001]

I want to get data and pass it variable without providing the field number something like

PHP код:

SELECT pMoney FROM users WHERE username='BLA' 


But I got

Код:

Tage mismatch

When I do it like that

[Luke_James]

PHP код:

SELECT `pMoney` FROM `users` WHERE `username` = 'BLA' 


[nezo2001]

My whole script without the (`) and it is working fine!
And I get the warning when I pass it to a variable....

[Macronix]

Then show us the code.

[nezo2001]

PHP код:

                new UMoney[128];
                new Smoney[128];
                format(Smoney, sizeof(Smoney), "SELECT pMoney FROM users WHERE pName='%s'",CarInfo[i][owner]);
                mysql_query(1, Smoney);
                format(UMoney, sizeof(UMoney), "UPDATE users SET pMoney='%i' WHERE username='%s'",Smoney+CarInfo[i][CarPrice], CarInfo[i][owner]);
                mysql_query(1, UMoney); 


[Logofero]

Quote:

Originally Posted by nezo2001 PHP код:                 new UMoney[128];                 new Smoney[128];                 format(Smoney, sizeof(Smoney), "SELECT pMoney FROM users WHERE pName='%s'",CarInfo[i][owner]);                 mysql_query(1, Smoney);                 format(UMoney, sizeof(UMoney), "UPDATE users SET pMoney='%i' WHERE username='%s'",Smoney+CarInfo[i][CarPrice], CarInfo[i][owner]);                 mysql_query(1, UMoney);

PHP код:

CarInfo[i][owner] // <- This is player ID or name? 


Your Waring occur because you are trying to save the format(); string <- integer