SQL_CALC_FOUND_ROWS / FOUND_ROWS() does not work in PHP

by

Thank you.

When I ran something analogous to your example on the mysql command line, it would work; but running it from php, it failed. The second query has to “know about” the first one, so I figure somehow that persistence/memory linking the two queries was getting messed up by the php.

(It turns out that WordPress uses this type of query to do its pagination – so our larger problem was that the pagination in a wordpress install suddenly stopped working when we moved to php 5.2.6 … eventually tracked it down to the FOUND_ROWS()).

Just for the sake of posting for people who may run into this in the future… for me it was the php setting “mysql.trace_mode” – this defaulted “on” in 5.2.6 instead of “off” like previously, and for some reason prevents the FOUND_ROWS() from working.

As a “fix”, we could either put this in every php page (actually, in a common “include”):

ini_set("mysql.trace_mode", "0");

or add this to the .htaccess:

php_value mysql.trace_mode "0"

Thanks again,
Jerry

More Related Contents:

  1. What to put in database columns when creating registration/login system? (xampp)
  2. drop down menu using php and mysql [closed]
  3. mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource
  4. How to properly set up a PDO connection
  5. Using PHP 5.5’s password_hash and password_verify function
  6. Search with comma-separated value mysql
  7. How to do this in Laravel, subquery where in
  8. I have an array of integers, how do I use each one in a mysql query (in php)? [duplicate]
  9. Levenshtein: MySQL + PHP
  10. PHP MySQLI Prevent SQL Injection [duplicate]
  11. mysql PDO how to bind LIKE
  12. How to test if a MySQL query was successful in modifying database table data?
  13. How do i “echo” a “Resource id #6” from a MySql response in PHP?
  14. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  15. Does mysql_real_escape_string() FULLY protect against SQL injection?
  16. Recursive categories with a single query?
  17. LOAD DATA LOCAL INFILE forbidden in… PHP
  18. How get all values in a column using PHP?
  19. Why does this return Resource id #2? [duplicate]
  20. In PHP with PDO, how to check the final SQL parametrized query? [duplicate]
  21. Date in a URL dd/mm/yyyy
  22. Insert current date in datetime format mySQL
  23. MySQL Query IN() Clause Slow on Indexed Column
  24. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  25. Finding free blocks of time in mysql and php?
  26. How do you make good use of multicore CPUs in your PHP/MySQL applications? [closed]
  27. Update query PHP MySQL [duplicate]
  28. Do I have to use mysql_real_escape_string if I bind parameters?
  29. How to get a list of databases?
  30. How to sort MYSQL fulltext search results by relevancy

Leave a Comment