title: SQL_CALC_FOUND_ROWS / FOUND_ROWS() does not work in PHP
body: <p>I use <code>SQL_CALC_FOUND_ROWS</code> in Mysql SELECT statement, to get the number of lines my SELECT would return without a LIMIT clause.</p>
  
  <pre><code>$sql = new mysqli('localhost', 'root', '');
  $sql-&gt;select_db('mysql');
  $s1 = $sql-&gt;query('select SQL_CALC_FOUND_ROWS * from db limit 0, 3');
  $s2 = $sql-&gt;query('select FOUND_ROWS()');
  if($row = $s2-&gt;fetch_row()) printf('%d/%d', $s1-&gt;num_rows, $row[0]);
  </code></pre>
  
  <p>On my WinXP dev station it return 3/0 everytime for several weeks. When I use another MySQL server from my station it return 3/0 too. 
  On anothers PC the same code runs fine, and return the correct number (3/17 for example, if I have 17 records in mysql.db table). Every XP PC have the same PHP/Mysql version, and it ran fine in the past on my PC
  Using Mysql Query Browser with the same SQL queries I get the right number.</p>
  
  <p>Could anyone give me an idea of solution, without re-install all?</p>
  
  <p>Sorry, my previous request was awfully unclear.</p>