Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2009
    Posts
    21

    Unanswered: SELECT FOUND_ROWS() not Working

    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?
    Last edited by sakis; 12-04-09 at 15:04.

  2. #2
    Join Date
    Nov 2009
    Posts
    21
    SOLVED

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

    after deleting that query it works fine !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •