title: how to get the total row count with mysqli
body: <p>i am trying to understand mysqli extension and did google but got very few info on this except php.net which was helpful. </p>
  
  <p>now after all this i am trying to achieve what i could with mysql extension which is as follows:</p>
  
  <pre><code>// MYSQL STYLE OF fetching array, query limit and perform total row count all at once
  
  $sql = "SELECT SQL_CALC_FOUND_ROWS *, post.id as pid, bla bla FROM account ORDER BY pid ASC". $eb["array"]['querylimit'];
  
  $result = mysql_query($sql, $eb["con"]);
  $TotalRcount = mysql_fetch_row(mysql_query("SELECT FOUND_ROWS()"));
  
  // Performing record count [current]
  // $RecordCount = mysql_num_rows($result);
  
  while($row = mysql_fetch_array($result)){
      // read columns
  }
  </code></pre>
  
  <p>with mysqli how can i achieve this? am sure i am missing many things. please help me with example on how to achieve my goal.</p>