title: Echo number of records in row with COUNT()
body: <p>How to get and echo number of records in row?this is my code</p>
  
  <pre><code>$b = "SELECT COUNT(Users) FROM room";
  $r= mysqli_query($connection,$b);
  $c = mysqli_fetch_array($r);
  echo $c['Users'];
  </code></pre>
  
  <p>I get this error while i have it in <code>room</code> table</p>
  
  <blockquote>
    <p>Notice: Undefined index: ID in C:\xampp\htdocs\php\blog0\rooms.php on
    line 31</p>
  </blockquote>