title: Get total number of rows when using LIMIT
body: <p>Been following examples from <a href="http://www.arraystudio.com/as-workshop/mysql-get-total-number-of-rows-when-using-limit.html">here</a> and many other sites but not getting the expected results</p>
  
  <p>Snippet of my PHP code;</p>
  
  <pre><code>$query="SELECT * FROM book";
  $result=mysql_query($query);
  echo mysql_num_rows($result); //returns 14
  
  
  $query="SELECT FOUND_ROWS()";
  $rtotal=mysql_query($query);
  echo mysql_result($rtotal,0); //returns 14
  
  
  $query="SELECT * FROM book LIMIT 0,4";
  $result=mysql_query($query);
  echo mysql_num_rows($result); //returns 4
  
  
  $query="SELECT FOUND_ROWS()";
  $rtotal=mysql_query($query);
  echo mysql_result($rtotal,0); //returns 4 Why is it 4 and not 14??
  </code></pre>
  
  <p>In the last example why is it 4 and not 14?? What am I doing wrong?</p>