sahaya
注册会员
UID 94827
精华
0
积分 57
帖子 38
金钱 57 喜悦币
威望 0
人脉 0
阅读权限 20
注册 2007-7-3
状态 离线
|
[广告]: q
m
第一次发贴 请教高手关于分页的问题(急!!!)
弄了个分页,单独运行可以,放在IF条件里就不能显示第一页后的内容了,请教高手指点一下该怎么做?谢谢了
<?php
$dbhostname = "localhost"; //mysql服务主机名
$dbusername = "root"; //mysql用户
$dbpassword = ""; //该用户的密码
$dbname = "test";
$table = "shujubiao";
@mysql_pconnect($dbhostname,$dbusername,$dbpassword) or die("不能连接服务器!");
@mysql_select_db($dbname) or die("不能选择数据库");
if($wenhao!=="")
{
$page=isset($_GET['page'])?intval($_GET['page']):1;
$num=3;
$total=mysql_num_rows(mysql_query("select * from $table WHERE wjlx = '$wenhao'"));
$pagenum=ceil($total/$num);
If($page>$pagenum || $page == 0){
Echo "Error : Can Not Found The page .";
Exit;}
$sql ="select * from $table WHERE wjlx = '$wenhao'";
$ok = mysql_query($sql);
$offset=($page-1)*$num;
$info=mysql_query("select * from $table WHERE wjlx = '$wenhao' LIMIT $offset,$num");
while($row=mysql_fetch_array($info,MYSQL_NUM)){
if($row[5]=="jiamiwenjian")
{
$link = "zzzzz2."."html";
echo "<a href= $link ><font color=Green>$row[3]</a>"."<br>";
}
else{
$link = "uploads/".$row[4];
echo "<a href= $link >$row[3]</a>"."<br>";
}
}
For($i=1;$i<=$pagenum;$i++){
$show=($i!=$page)?"<a href='uploadchaxun7.php?page=".$i."'>$i</a>":"<b>$i</b>";
Echo $show." ";}
}
?>
|
|
