Simple enough….

$result = mysql_query('SELECT * FROM table1');
$num_rows = mysql_num_rows($result);

$num_rows returns the number of records returned by the query….