Command out of sync. I give rep !!!!
#2

With mysql_query() - you must use mysql_store_result() after the query if you're using a SELECT statement.

For example

Код:
       format(query, sizeof(query), "SELECT playerName, playerGroupRank, playerCarWeapon3 FROM playeraccounts WHERE playerGroup = %d ORDER BY playerGroupRank DESC LIMIT 10",playerVariables[playerid][pGroup]);
        mysql_query(query);
        format(test, sizeof(test), "SELECT playerGroupRank FROM playeraccounts WHERE playerGroup = %d",playerVariables[playerid][pGroup]);
        mysql_query(test);
        mysql_store_result();
        while(mysql_retrieve_row())
        {

        }
        mysql_free_result();
        format(test2, sizeof(test2), "SELECT playerCarWeapon3 FROM playeraccounts WHERE playerGroup = %d",playerVariables[playerid][pGroup]);
        mysql_query(test2);
        mysql_store_result();
        new memid;
        while(mysql_retrieve_row())
        {
Reply


Messages In This Thread
Command out of sync. I give rep !!!! - by buburuzu19 - 09.10.2014, 13:15
Re: Command out of sync. I give rep !!!! - by DowntownGangster - 09.10.2014, 13:40
Re: Command out of sync. I give rep !!!! - by buburuzu19 - 09.10.2014, 13:44
Re: Command out of sync. I give rep !!!! - by DowntownGangster - 09.10.2014, 13:47
Re: Command out of sync. I give rep !!!! - by thefatshizms - 09.10.2014, 14:05

Forum Jump:


Users browsing this thread: 2 Guest(s)