FOUND_ROWS() Fails in PHP
<p>I need to retrieve the  total count of records after executing a query. I tried like this</p>

<pre><code>&lt;?php
include_once 'common.php';

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

$sql ="get_list(0, 40, 'Name', 'DESC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)";

$con = mysqli_connect("localhost", "root", "");

mysqli_select_db( $con, "crash_table");

mysqli_query($con, $sql);

$sql2= "SELECT FOUND_ROWS();";

$result = mysqli_query($con, $sql2);

$count = mysqli_fetch_array($result);

echo "Count=".$count[0];

?&gt;
</code></pre>

<p>but the count is always 0. In the code get_list() is a procedure where 40 is the LIMIT.. Why is it so?</p>
