How to count total rows from table and fetch data

<?php 
$i=0;
$sqlcm ="select * from movie";
 $runcm = mysql_query($sqlcm);
while($datacm=mysql_fetch_array($runcm))
{$i++;
?>
<label></label>

<?php } echo $i; ?>