1 <?php
2 $sql="SELECT aid FROM `table`";
3 $query=mysql_query($sql);
4 $total=mysql_num_rows($query);
5 ?>
方法二、
1 <?php
2 $sql="SELECT count(*) FROM `table`";
3 $query=mysql_query($sql);
4 if($rs=mysql_fetch_array($query)){
5 $total=$rs[0];
6 }else{
7 $total=0;
8 }
9 ?>