Count particular row in database

Count particular row in database using mysql query,


$query = mysql_query(SELECT COUNT(rowname) from table name);
echo $query;