09.10.2014, 13:40
With mysql_query() - you must use mysql_store_result() after the query if you're using a SELECT statement.
For example
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()) {