use mysql_num_rows on your query.
http://php.net/manual/en/function.mysql-num-rows.php
Considering moveing away from mysql to mysqli or PDO if you are a new.
Instead of learning an outdated and no more supported mysql.
1
solved Getting total number of registered users [duplicate]