[pride95]

PHP Code:

FormatEx(query, sizeof(query), "SELECT count(*), s2.score, s2.hours FROM table s JOIN table s2 ON s2.steamid = '%s' AND (s.score > s2.score OR s.score = s2.score AND s.name <= s2.name);", Steam); 


For this query SQL_MoreRows returns true even if my database is empty. i need to create another query for false:

PHP Code:

select x form table while steamid = ""; this is example, not the code from plugin 


why for the first query morerows returns true and for the second returns false?

[quake84]

Because the "count(*)" in your query will always return a row with the result of the count(*) function regardless of the data - that is, even if the table is empty!!!!

[pride95]

so, something like this will works?

if(!SQL_MoreRows(hndl) || !SQL_FetchInt(hndl, 0))

SQL_FetchInt = count(*)

[quake84]

if(!SQL_MoreRows(hndl) || (SQL_FetchRow(hndl) && !SQL_FetchInt(hndl, 0)))

You need to FetchRow() before fetching anything from a row.