Mysql error! help +rep
#7

Quote:
Originally Posted by Vince
Посмотреть сообщение
Read the error closely:
Код:
in 'order clause'
That means you're looking for a query that has ORDER BY in it.
I have already ordered him complete.

here is all quarry list

pawn Код:
Query("INSERT INTO `playerinfo` (`user`,`password`,`IP`,`date`) VALUES ('%s',%d,'%s',%d)",

SaveStats(playerid)
{
    if (!gPlayerInfo[playerid][pLogged]) return 1;
    new query[300];
    Query("UPDATE `playerinfo` SET `score`='%d',`money`='%d',`kills`='%d',`deaths`='%d',`level`='%d',`operator`='%d',`donor`='%d',`pilot`='%d',`isnavy`='%d',`hourson`='%d', `tag`='%d' WHERE `id`='%i'",
    gPlayerInfo[playerid][pScore],gPlayerInfo[playerid][pMoney],gPlayerInfo[playerid][pKills],gPlayerInfo[playerid][pDeaths],
    gPlayerInfo[playerid][pAlevel],gPlayerInfo[playerid][pOp],gPlayerInfo[playerid][pDonor],gPlayerInfo[playerid][pPilot],gPlayerInfo[playerid][pNavy], gPlayerInfo[ playerid ][ Hours ], gPlayerInfo[playerid][pTAG],
    gPlayerInfo[playerid][pDBID]);
    mysql_query(query); //queries
    SendClientMessage(playerid,YELLOW,"Stats saved!");
    return 1;
}
Reply


Messages In This Thread
Mysql error! help +rep - by Ryz - 05.10.2014, 06:42
Re: Mysql error! help +rep - by yanir3 - 05.10.2014, 08:25
Re: Mysql error! help +rep - by Ryz - 05.10.2014, 08:53
Re: Mysql error! help +rep - by Ryz - 05.10.2014, 09:14
Re: Mysql error! help +rep - by MacT - 05.10.2014, 10:18
Re: Mysql error! help +rep - by Vince - 05.10.2014, 10:26
Re: Mysql error! help +rep - by Ryz - 05.10.2014, 11:16

Forum Jump:


Users browsing this thread: 6 Guest(s)