php的显示记录
好久没有弄了,复习一下!
<div id="topname">::热门话题</div>
<?php
$query_top_rs = "SELECT id,title FROM ruby WHERE view=1 order by countruby desc LIMIT 0,10";
//The updated article 10
$top_rs = mysql_query($query_top_rs, $conn) or die(mysql_error());
$row_top_rs = mysql_fetch_assoc($top_rs);
do { ?>
<div id="toplist">
<img src="images/arrow_list.gif" width="13" height="11" /><a href=/show.php/<?php echo $row_top_rs['id']; ?>.html
title="<?php echo $row_top_rs['title']; ?>"
target="_blank"
><?php echo cnSubStr($row_top_rs['title'],28); ?>
</a>
</div>
<?php } while ($row_top_rs = mysql_fetch_assoc($top_rs));
mysql_free_result($top_rs);//Memory release
?><br/>
<?php
$query_top_rs = "SELECT id,title FROM ruby WHERE view=1 order by countruby desc LIMIT 0,10";
//The updated article 10
$top_rs = mysql_query($query_top_rs, $conn) or die(mysql_error());
$row_top_rs = mysql_fetch_assoc($top_rs);
do { ?>
<div id="toplist">
<img src="images/arrow_list.gif" width="13" height="11" /><a href=/show.php/<?php echo $row_top_rs['id']; ?>.html
title="<?php echo $row_top_rs['title']; ?>"
target="_blank"
><?php echo cnSubStr($row_top_rs['title'],28); ?>
</a>
</div>
<?php } while ($row_top_rs = mysql_fetch_assoc($top_rs));
mysql_free_result($top_rs);//Memory release
?><br/>
手足口综合征食疗配方
apache 防盗链两例
