hello, can you test this and tell us results?
Code:
public CountEntries(){
new query[256]
formatex(query, charsmax(query), "SELECT COUNT(*) FROM `%s`;", MYSQL_TABLE)
SQL_ThreadQuery(MYSQL_CONNECTION, "SQLCountEntries", query)
}
public SQLCountEntries(failState, Handle:query, error[], errNum){
new entries = 0
if(SQL_NumResults(query)){
entries = SQL_ReadResult(query, 0)
server_print("entries[%d]", entries)
}
}
__________________