Counting Records via SQL Query in PHP

Using the COUNT command, you can count the number of rows in a result set.

Let's, for example, count all users in the table:

php<?php
  $query = "SELECT COUNT(*) FROM users";
?>

And now let's count all users whose salary is equal to 900:

php<?php
  $query = "SELECT COUNT(*) FROM users WHERE salary=900";
?>