[SOLVED] SQL_CALC_FOUND_ROWS

[The Little Guy]

OK, I am not getting my FOUND_ROWS() function to work in the following code:

$_id = 1;
$limit = 0;
$max = 8;
$sql = mysql_query("SELECT SQL_CALC_FOUND_ROWS * FROM images WHERE owner = '$_id' ORDER by id DESC LIMIT $limit, $max")or die(mysql_error());
$result_count = mysql_query("SELECT FOUND_ROWS()")or die(mysql_error());
$total = mysql_fetch_array($result_count);
$totalrows = $total[0];
echo $totalrows;

 

If I were to remove the LIMIT, I would get 12 results, but $totalrows echo's out 0. What could have happened for this not to work, or am I missing something?

 

This used to work before, but now it doesn't work, and I don't know why...

[phpSensei]

try

 

$_id = 1;
$limit = 0;
$max = 8;
$sql = mysql_query("SELECT SQL_CALC_FOUND_ROWS * FROM images WHERE owner = '$_id' ORDER by id DESC LIMIT $limit, $max")or die(mysql_error());
$result_count = mysql_query("SELECT FOUND_ROWS() as `found_rows`")or die(mysql_error());
$total = mysql_fetch_array($result_count);
$totalrows = $total['found_rows'];
echo $totalrows;

[The Little Guy]

hmmm.... Nope, but if I run both the queries in PHPMyAdmin, it returns the correct number of results.... If I run it in my php, I get 0...

 

Could it be because I have Apache mod_gzip disabled and/or the output buffer = 0 in my php.ini file?

[phpSensei]

Try turning them on, and see what happens.

 

edit: I dont see how mod_gizp would affect this, I did some research and found nothing related between the two.

 

Turn on error_reporting and see what happens.

[The Little Guy]

I don't have access to the Apache configuration files, but changing the PHP ini file's output buffer to 4096, and it still doesn't work.

[phpSensei]

I just tested and I am actually getting the same problem on my server. What a small world...

 

mod_gzip is enabled here

[The Little Guy]

GOT IT!!

 

Change:

mysql.trace_mode = on

 

To:

mysql.trace_mode = false

 

in your php.ini file

[phpSensei]

GOT IT!!

 

Change:

mysql.trace_mode = on

 

To:

mysql.trace_mode = false

 

in your php.ini file

 

thanks man, haha should have been the other way around, but always learn something new...

 

this is going in my notes