Hey. I'm running into some confusion with SourceMod's SQL_GetRowCount.
I'm able to create tables, insert/update data etc. But the following code always returns 1:
PHP Code:
// Get number of rows in table "competitive_overlay"
new Handle:hSQL_RowCount = SQL_Query(g_hSQL, "SELECT COUNT(*) FROM `competitive_overlay`;");
new rowCount = SQL_GetRowCount(hSQL_RowCount);
CloseHandle(hSQL_RowCount);
PrintToServer("Row count: %i", rowCount); // This is always 1
Running "SELECT COUNT(*) FROM `competitive_overlay`" directly in the SQL server returns the actual row count just fine. Am I doing something wrong here?
Threaded Mode