if ($page){
$query="select count(*) as total from news";
$result=mysql_query($query,$db);
$message_count=mysql_result($result,0,"total");
$page_count=ceil($message_count/$page_size);
$offset=($page-1)*$page_size;
$query="select * from news order by id desc limit $offset, $page_size";
$result=mysql_query($query,$db);
if($result){
$rows=mysql_num_rows($result);
$i=1;
?></b></font></td>
</tr>
<tr valign="top">
<td>
<table width="703" border="0">
<?php
while($myrow=mysql_fetch_array($result)){
?>
<tr>
<td bgcolor="#CCFFFF" width="21"></td>
<td bgcolor="#EEEEEE" width="462"><a href="javascript:view('view_d.php3?recid=<?php echo $myrow[id]; ?>')">
</a><a href="javascript:view('view_d.php3?recid=<?php echo $myrow[id]; ?>')"><?php echo $myrow[title];?></a></td>
<td bgcolor="#EEEEEE" width="218">发布时间:<? echo $myrow[pub_time]; ?>
</td>
</tr>
<?php
$i++;
if ($i<=$rows){
echo "";
}
}
?>
</table>
<?php
$prev_page=$page-1;
$next_page=$page+1;?>
<?php
if ($page<=1){
echo "第一页";
}
else{
echo "<a href='$PATH_INFO?page=1'>第一页</a>";
}
echo " ";
if ($prev_page<1){
echo "上一页";
}
else{
echo "<a href='$PATH_INFO?page=$prev_page'>上一页</a>";
}
echo " ";
if ($next_page>$page_count){
echo "下一页";
}
else{
echo "<a href='$PATH_INFO?page=$next_page'>下一页</a>";
}
echo " ";
if ($page>=$page_count){
echo "最后一页";
}
else{
echo "<a href='$PATH_INFO?page=$page_count'>最后一页</a>";
}
}
else{
echo "<p align='center'>现在还没有新闻!/p>";
}
}
?> </td>
<?php
if ($page){
$query="select count(*) as total from it_news";
$result=mysql_query($query,$db);
$message_count=mysql_result($result,0,"total");
$page_count=ceil($message_count/$page_size);
$offset=($page-1)*$page_size;
$query="select * from it_news order by id desc limit $offset, $page_size";
$result=mysql_query($query,$db);
if($result){
$rows=mysql_num_rows($result);
$i=1;
?>
我的新闻主页片断,虽然无法直接使用,但可以提供一个参考,具体到带图片,需要你自己修饰了
$query="select count(*) as total from news";
$result=mysql_query($query,$db);
$message_count=mysql_result($result,0,"total");
$page_count=ceil($message_count/$page_size);
$offset=($page-1)*$page_size;
$query="select * from news order by id desc limit $offset, $page_size";
$result=mysql_query($query,$db);
if($result){
$rows=mysql_num_rows($result);
$i=1;
?></b></font></td>
</tr>
<tr valign="top">
<td>
<table width="703" border="0">
<?php
while($myrow=mysql_fetch_array($result)){
?>
<tr>
<td bgcolor="#CCFFFF" width="21"></td>
<td bgcolor="#EEEEEE" width="462"><a href="javascript:view('view_d.php3?recid=<?php echo $myrow[id]; ?>')">
</a><a href="javascript:view('view_d.php3?recid=<?php echo $myrow[id]; ?>')"><?php echo $myrow[title];?></a></td>
<td bgcolor="#EEEEEE" width="218">发布时间:<? echo $myrow[pub_time]; ?>
</td>
</tr>
<?php
$i++;
if ($i<=$rows){
echo "";
}
}
?>
</table>
<?php
$prev_page=$page-1;
$next_page=$page+1;?>
<?php
if ($page<=1){
echo "第一页";
}
else{
echo "<a href='$PATH_INFO?page=1'>第一页</a>";
}
echo " ";
if ($prev_page<1){
echo "上一页";
}
else{
echo "<a href='$PATH_INFO?page=$prev_page'>上一页</a>";
}
echo " ";
if ($next_page>$page_count){
echo "下一页";
}
else{
echo "<a href='$PATH_INFO?page=$next_page'>下一页</a>";
}
echo " ";
if ($page>=$page_count){
echo "最后一页";
}
else{
echo "<a href='$PATH_INFO?page=$page_count'>最后一页</a>";
}
}
else{
echo "<p align='center'>现在还没有新闻!/p>";
}
}
?> </td>
<?php
if ($page){
$query="select count(*) as total from it_news";
$result=mysql_query($query,$db);
$message_count=mysql_result($result,0,"total");
$page_count=ceil($message_count/$page_size);
$offset=($page-1)*$page_size;
$query="select * from it_news order by id desc limit $offset, $page_size";
$result=mysql_query($query,$db);
if($result){
$rows=mysql_num_rows($result);
$i=1;
?>
我的新闻主页片断,虽然无法直接使用,但可以提供一个参考,具体到带图片,需要你自己修饰了
这叫不劳而获!
让别人写好程序,你去交差,你太聪明了吧!