<?php
$link=mysql_connect("localhost","****","*****");
if($link){}
else {echo "数据库连接失败!<br>";}//测试连接数据库是否成功
$db=mysql_select_db("test");
$query="select school_news.nid,school_news.zt,school_news.sj from school_news order by nid desc";
$row=mysql_query($query);
$rows=mysql_num_rows($row);//检查表中共有多少条记录order by id desc limit
//echo "<font size=2>共有新闻:".$rows."条</font>";
echo "<br><table width='98%' border='0' cellspacing='0' cellpadding='0'>";
$j=0;
while($rowt=mysql_fetch_row($row)){
$j++;
if((($j+4)==$rows) ){
echo "<tr>";
for($i=0;$i<count($rowt);$i++){
if($i!=5){ echo "<td align=left><font size=2>".$rowt[$i]."</font></td>"; }
}
echo "</tr>";
}else continue;
}
echo "</table>";
?>
$link=mysql_connect("localhost","****","*****");
if($link){}
else {echo "数据库连接失败!<br>";}//测试连接数据库是否成功
$db=mysql_select_db("test");
$query="select school_news.nid,school_news.zt,school_news.sj from school_news order by nid desc";
$row=mysql_query($query);
$rows=mysql_num_rows($row);//检查表中共有多少条记录order by id desc limit
//echo "<font size=2>共有新闻:".$rows."条</font>";
echo "<br><table width='98%' border='0' cellspacing='0' cellpadding='0'>";
$j=0;
while($rowt=mysql_fetch_row($row)){
$j++;
if((($j+4)==$rows) ){
echo "<tr>";
for($i=0;$i<count($rowt);$i++){
if($i!=5){ echo "<td align=left><font size=2>".$rowt[$i]."</font></td>"; }
}
echo "</tr>";
}else continue;
}
echo "</table>";
?>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货