php(限制while循环显示的记录数)急急!!!!!!!!!!

[liangling221]

$str="select tgbs as bs,tgbt as bt from tgsp where status = 1 and getdate() between isnull(fbqsrq,getdate()) and isnull(fbjzrq,getdate()) order by case when gmcs is null then 999999 else gmcs end desc";
$ph_query = tep_db_query($str);

<?
while($paih = tep_db_fetch_array($ph_query)){
?>
<li>· <? echo ' <a class="L100" title="'.$paih['bt'].'" href="'.tep_href_link('tuangoushow.php','id='.$paih['bs']) .'" target=_parent> <script>document.write("'.$paih['bt'].'".length>9?"'.$paih['bt'].'".substring(0,9)+"...":"'.$paih['bt'].'"); </script> </a> ' ?> </li>
<?php
}
?>
比如sql语句能查出10条记录,但是在用while 循环的时候只显示7条,在不改变sql 语句的情况下只改变while循环
来实现这个效果,请大家帮忙..谢谢.....

[leec1981]

设置一个变量，显示一条加1，显示7条后就不再显示了

[zcl8624]

$str="select tgbs as bs,tgbt as bt from tgsp where status = 1 and getdate() between isnull(fbqsrq,getdate()) and isnull(fbjzrq,getdate()) order by case when  gmcs is null then 999999 else gmcs end desc";  
$ph_query = tep_db_query($str);  

<?  
$i = 0;//增加一个自增字段
$num = 7;//需要的记录数
while($paih = tep_db_fetch_array($ph_query)){ 
if($i == $num){  //如果记录数与已循环次数相等，则跳出循环
   break;
} 
?>  
<li>·  <? echo '  <a   class="L100"  title="'.$paih['bt'].'" href="'.tep_href_link('tuangoushow.php','id='.$paih['bs']) .'" target=_parent>  <script>document.write("'.$paih['bt'].'".length>9?"'.$paih['bt'].'".substring(0,9)+"...":"'.$paih['bt'].'");  </script>  </a> ' ?>    </li>   
<?php  
$i++;
}  
?>