[IceCucumber]

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?

[Exolent[jNr]]

Because the number of rows returned is not the same number as COUNT(*).
It returns 1 row with the value of the COUNT(*).
So you have to fetch the first integer value from the row given.

[IceCucumber]

Ah. Thank you.