Posts: 2,286
Threads: 18
Joined: Jun 2010
Quote:
Originally Posted by -=Dar[K]Lord=-
pawn Код:
new acctext[64]; new totalaccs; mysql_query("SELECT * FROM players"); mysql_store_result(); mysql_fetch_field_row(totalaccs,"STRINGWHICHHOLDSTHECOUNT");//Change the "STRINGWHICHHOLDSTHECOUNT" with your var which saves the total count mysql_free_result(); format(acctext, sizeof(acctext), "Total accounts: %d", totalaccs);
TextDrawSetString(totalacc, acctext); TextDrawShowForPlayer(playerid, totalacc); //totalacc is the textdraw.
Should Work try it out
#EDITED: My bad, code was kinda wrong
|
NEVER use SELECT * to get row count. That's what SELECT COUNT is for.