请教DWZ PHP网站后台换页问题
本帖最后由 gdljw 于 2013-03-30 11:45:59 编辑 最后搞PHP+DWZ做网站后台，网上找到这代码，试用正常可以换页,但是我想加一个条件caidid=caidid分页，直接在$sql= "select id,u_id,u_name,last_logintime,last_ip,last_imei,last_phone_number,last_logintype from users where CateId='$CateId2' and $tiaojian like '%$neirong%' order by $orderField {$orderDirection} limit {$fup_page},{$numPerPage}";
就换不了页了，请问要怎设置？
就换不了页了，请问要怎设置？
<?php<br> require_once '../include/config.php';<br>$connect = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD)<br> or die('Could not connect to mysql server.');<br><br> mysql_select_db(DB_DATABASE, $connect)<br> or die('Could not select database.');<br>?><br><br><?php<br>echo '<form id="pagerForm" method="post" action="back/user.php"><br><input name="status" value="'.$status.'" type="hidden"><br><input name="keywords" value="'.$keywords.'" type="hidden"><br><input name="pageNum" value="1" type="hidden"><br><input name="numPerPage" value="'.$numPerPage.'" type="hidden"><br><input name="CateId2" value="'.$CateId2.'" type="hidden"><br><input name="orderField" value="'.$orderField.'" type="hidden"><br><input name="orderDirection" value="'.$orderDirection.'" type="hidden"><br></form>';<br>//定义条件sql<br><br>$CateId = get_CateId_by_UId( $UId );<br>$tiaojian = empty($_POST["tiaojian"])?'u_name':$_POST["tiaojian"];<br>$neirong = empty($_POST["keywords"])?"":$_POST["keywords"];<br>$CateId2 = empty($_POST["CateId2"])?'CateId':$_POST["CateId2"];<br>$orderField = empty($_POST["orderField"])?"id":$_POST["orderField"];<br>$query = mysql_query("select * from users");<br>$totalCount = mysql_num_rows($query);<br>$pageNumShown=10;<br>$_POST["pageNum"]!=""?$pageNum=$_POST["pageNum"]:$pageNum=1;<br>$numPerPage=empty($_POST["numPerPage"])?20:$_POST["numPerPage"];<br>$fup_page=($pageNum-1)*$numPerPage;<br>$sql= "select id,u_id,u_name,last_logintime,last_ip,last_imei,last_phone_number,last_logintype from users where $tiaojian like '%$neirong%' order by $orderField {$orderDirection} limit {$fup_page},{$numPerPage}";<br>$result = mysql_query($sql);<br>?><div class="clear">
</div>
