不知道下面的代码哪里有问题,死也调不出来啊!求教大家--急啊!<?php $link = mysql_connect("localhost", "root", "") or
die("Could not connect: " . mysql_error()); mysql_select_db("forum",$link);
$result = mysql_query("SELECT * FROM article"); function readnum()
{
global $link;
$sql = "select id from article where id>0";
$result = mysql_query($sql, $link);
$total = mysql_num_rows($result);
return $total;
}
//文章的总数目
$total = readnum(); //可以修改每页的显示行数
$num_row =5; //计算总页数
//ceil()计算大于指定数的最小整数
$num_page = ceil($total/$num_row);
if ($total > 0)
{
if (empty($nowpage))
{
$nowpage = 1;
}
}
function pri_page($formname, $nowpage, $num_page)
{
echo "<TABLE>";
echo "<TBODY>";
echo "<TR>";
echo "<TD width='50%' height='15'> </TD>";
echo "<TD width='10%' height='15'>";
echo "<DIV align='center'>";
if ($nowpage <= 1)
{
echo "首页";
}
else
{
echo "<A href='JavaScript:document.$formname.nowpage.value=1;";
echo "$formname.submit();'>首页</A>";
}
echo "</DIV>";
echo "</TD>"; echo "<TD width='10%' height='15'>";
echo "<DIV align='center'>";
if ($nowpage <= 1)
{
echo "|上一页";
}
else
{
echo "<A href='JavaScript:document.$formname.nowpage.value=$nowpage-1";
echo "$formname.submit();'>|上一页</A>";
}
echo "</DIV>";
echo "</TD>";
echo "<TD width='10%' height='15'>";
echo "<DIV align='center'>";
echo "$nowpage/$num_page";
echo "</DIV>";
echo "</TD>"; echo "<TD width='10%' height='15'>";
echo "<DIV align='center'>";
if ($nowpage >= $num_page)
{
echo "|下一页";
}
else
{
echo "<A href='JavaScript:document.$formname.nowpage.value=$nowpage+1;";
echo "$formname.submit();'>|下一页</A>";
}
echo "</DIV>";
echo "</TD>"; echo "<TD width='10%' height='15'>";
echo "<DIV align='center'>";
if ($nowpage >= $num_page)
{
echo "结尾页";
}
else
{
echo "<A href='JavaScript:document.$formname.nowpage.value=$num_page;";
echo "$formname.submit();'>|结尾页</A>";
}
echo "</DIV>";
echo "</TD>";
echo "</TR>";
echo "</TBODY>";
echo "</TABLE>";
}
?>
<table width="100%" bgcolor="#FFFF00">
<tr>
<td width="6%" align="center" height="16"><u><b>序号</b></u></td>
<td width="18%" align="center" height="16"><b><u>标题</u></b></td> <td width="17%" align="center" height="16"><b><u>发表日期</u></b></td>
<td width="18%" align="center" height="16"><b><u>发表人</u></b></td>
</tr>
</table>
<? while ($row = mysql_fetch_row($result)) { //print_r($row);
?>
<table width="100%" bgcolor="#FFFF00">
<tr>
<td width="6%" align="center" height="4"><?=$row[0]?></td>
<td width="18%" align="center" height="4"><a href="show.php?id=<?=$row[0]?>" ><?=$row[1]?></a></td> <td width="17%" align="center" height="4"><?=$row[3]?></td>
<td width="18%" align="center" height="4"><?=$row[4]?></td>
</tr>
</table>
<hr>
<? } //调用分页显示格式,"list"为表单名
pri_page("list", $nowpage, $num_page, $cryptname);
mysql_free_result($result);
mysql_close($link);
?>
die("Could not connect: " . mysql_error()); mysql_select_db("forum",$link);
$result = mysql_query("SELECT * FROM article"); function readnum()
{
global $link;
$sql = "select id from article where id>0";
$result = mysql_query($sql, $link);
$total = mysql_num_rows($result);
return $total;
}
//文章的总数目
$total = readnum(); //可以修改每页的显示行数
$num_row =5; //计算总页数
//ceil()计算大于指定数的最小整数
$num_page = ceil($total/$num_row);
if ($total > 0)
{
if (empty($nowpage))
{
$nowpage = 1;
}
}
function pri_page($formname, $nowpage, $num_page)
{
echo "<TABLE>";
echo "<TBODY>";
echo "<TR>";
echo "<TD width='50%' height='15'> </TD>";
echo "<TD width='10%' height='15'>";
echo "<DIV align='center'>";
if ($nowpage <= 1)
{
echo "首页";
}
else
{
echo "<A href='JavaScript:document.$formname.nowpage.value=1;";
echo "$formname.submit();'>首页</A>";
}
echo "</DIV>";
echo "</TD>"; echo "<TD width='10%' height='15'>";
echo "<DIV align='center'>";
if ($nowpage <= 1)
{
echo "|上一页";
}
else
{
echo "<A href='JavaScript:document.$formname.nowpage.value=$nowpage-1";
echo "$formname.submit();'>|上一页</A>";
}
echo "</DIV>";
echo "</TD>";
echo "<TD width='10%' height='15'>";
echo "<DIV align='center'>";
echo "$nowpage/$num_page";
echo "</DIV>";
echo "</TD>"; echo "<TD width='10%' height='15'>";
echo "<DIV align='center'>";
if ($nowpage >= $num_page)
{
echo "|下一页";
}
else
{
echo "<A href='JavaScript:document.$formname.nowpage.value=$nowpage+1;";
echo "$formname.submit();'>|下一页</A>";
}
echo "</DIV>";
echo "</TD>"; echo "<TD width='10%' height='15'>";
echo "<DIV align='center'>";
if ($nowpage >= $num_page)
{
echo "结尾页";
}
else
{
echo "<A href='JavaScript:document.$formname.nowpage.value=$num_page;";
echo "$formname.submit();'>|结尾页</A>";
}
echo "</DIV>";
echo "</TD>";
echo "</TR>";
echo "</TBODY>";
echo "</TABLE>";
}
?>
<table width="100%" bgcolor="#FFFF00">
<tr>
<td width="6%" align="center" height="16"><u><b>序号</b></u></td>
<td width="18%" align="center" height="16"><b><u>标题</u></b></td> <td width="17%" align="center" height="16"><b><u>发表日期</u></b></td>
<td width="18%" align="center" height="16"><b><u>发表人</u></b></td>
</tr>
</table>
<? while ($row = mysql_fetch_row($result)) { //print_r($row);
?>
<table width="100%" bgcolor="#FFFF00">
<tr>
<td width="6%" align="center" height="4"><?=$row[0]?></td>
<td width="18%" align="center" height="4"><a href="show.php?id=<?=$row[0]?>" ><?=$row[1]?></a></td> <td width="17%" align="center" height="4"><?=$row[3]?></td>
<td width="18%" align="center" height="4"><?=$row[4]?></td>
</tr>
</table>
<hr>
<? } //调用分页显示格式,"list"为表单名
pri_page("list", $nowpage, $num_page, $cryptname);
mysql_free_result($result);
mysql_close($link);
?>
$nowpage=1;$start_record=($nowpage-1)*num_page;
if($start_record==0)
$start_record=1;
$last_record=$nowpage*$num_page;
if($last_record>$total)
$last_record=$total;select * from article limit $start_record,$last_record;随手写的 你自己看着改一下