整个的sql语句如下:
$sql="select * from notice ORDER BY ID DESC LIMIT 5;
$result=mysql_query($sql);//返回true
if ($result)
{
$rows=mysql_num_rows($result);
for($i=0;$i<$rows;$i++)
{//将通知的主题,时间,人员显示
mysql_data_seek($result,$i);
$rs=mysql_fetch_array($result);
$notice_ID=$rs["ID"]; $news_sub=$rs["NewsSub"];
$news_time=$rs["NewsTime"];//只精确到日
$real_name=$rs["RealName"];
print("<br>");
?>
<span class="style13">
<? echo "$real_name"?>
</span>
<span class="style6">--</span>
<span class="style2">
<? echo "$news_time"?>
</span>
<span class="style2">通知:</span><br>
<span class="style13">
<a href="news_broad/broad_xianxhi.php?display_noticeid=<? echo "$rs[ID] "?>">
<? echo "$news_sub" ?></a>
</span>
<br>
<?
}
}
?>
$sql="select * from notice ORDER BY ID DESC LIMIT 5;
$result=mysql_query($sql);//返回true
if ($result)
{
$rows=mysql_num_rows($result);
for($i=0;$i<$rows;$i++)
{//将通知的主题,时间,人员显示
mysql_data_seek($result,$i);
$rs=mysql_fetch_array($result);
$notice_ID=$rs["ID"]; $news_sub=$rs["NewsSub"];
$news_time=$rs["NewsTime"];//只精确到日
$real_name=$rs["RealName"];
print("<br>");
?>
<span class="style13">
<? echo "$real_name"?>
</span>
<span class="style6">--</span>
<span class="style2">
<? echo "$news_time"?>
</span>
<span class="style2">通知:</span><br>
<span class="style13">
<a href="news_broad/broad_xianxhi.php?display_noticeid=<? echo "$rs[ID] "?>">
<? echo "$news_sub" ?></a>
</span>
<br>
<?
}
}
?>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货