Hi

I am running a query
which uses the
SELECT SQL_CALC_FOUND_ROWS .... LIMIT 0,10

then this query is being executed
SELECT FOUND_ROWS()

but it returns 1 while the rows that should count are much more.

Mysql version is 5.1.33-community
and some of the tables are using indexes

Any idea about why could this happen?

SOLVED

I Was executing a mysql_error() query between the
Select Found....
and FOUND_ROWS

after deleting that query it works fine !