PHP, Mysql get the number of rows in a result

Retrieves the number of rows from a result set. This command is only valid for statements like SELECT or SHOW that return an actual result set.

<?php

mysql_connect(‘localhost’, ‘root’, ‘password’);
mysql_select_db(‘Database-Name’);

$query = mysql_query (“SELECT * FROM File-Name”);
$total= mysql_num_rows ($query);
?>
Record Total= <? echo $total; ?>