MYSQL Saving
#6

Well, I'm test this if it works or what.

PHP код:
  new query[500];
    if(
IsLoggedIn[playerid] == && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))
    {
        
format(query,sizeof(query), "UPDATE `players` SET `Money`=%d, `Score`=%d",
        
GetPlayerMoney(playerid),GetPlayerScore(playerid));
        
mysql_tquery(MySQLConquery"""");
        
format(query,sizeof(query), "`Medical`=%d WHERE `user`='%e'",
        
pInfo[playerid][pMedical],PlayerName(playerid));
        
mysql_tquery(MySQLConquery"""");
        print(
query);
    } 
it only update MONEY and SCORE. It doesn't update medical. What's wrng? Im trying to split it in two lines . Anyone can tell me how can i do that with stract?
Reply


Messages In This Thread
MYSQL Saving - by STONEGOLD - 29.06.2015, 23:39
Re: MYSQL Saving - by nezo2001 - 29.06.2015, 23:48
Re: MYSQL Saving - by kloning1 - 30.06.2015, 05:38
Re: MYSQL Saving - by Cheesus - 30.06.2015, 08:33
Re: MYSQL Saving - by STONEGOLD - 30.06.2015, 09:25
Re: MYSQL Saving - by STONEGOLD - 30.06.2015, 10:15
Re: MYSQL Saving - by Suicidal.Banana - 30.06.2015, 10:32
Re: MYSQL Saving - by STONEGOLD - 30.06.2015, 10:37
Re: MYSQL Saving - by Suicidal.Banana - 30.06.2015, 11:08
Re: MYSQL Saving - by STONEGOLD - 30.06.2015, 11:11

Forum Jump:


Users browsing this thread: 1 Guest(s)