Count the number of rows in a MySQL query, the COUNT function

Many times it'snecessary to count the result lines of a query. There are two ways to do this, php (mysql_num_rows) and MySQL with the COUNT. In this post I show the MySQL COUNT function.