title: number of rows in a table
body: <pre><code> &lt;?php
      include('connnect.php');
      db_connect();
      echo 'We\'re about to count some rows';
      $query = "SELECT COUNT(*) FROM accounts";
      $result = mysqli_query($mysqli,$query);
      $row = $result-&gt;fetch_row();
     echo $row[0];
    ?&gt;
  </code></pre>
  
  <p>I can't seem to find out how to get the number of rows(users) in the accounts table, this code simply returns nothing. I'm not sure if I'm passing the right information into 'num_rows' or if the query that I'm using is correct.</p>