<?php 

$sql = "SELECT * FROM .....";

$query = mysql_quer($sql);

$count = mysql_num_rows($query); // here you get the  total count values..

 ?>