I would like to ask questions about page change in the background of the DWZPHP website-php Tutorial

Ask the DWZPHP website back-end page change question this post was last edited by gdljw in 2013-03-3011: 45: 59 and finally engaged in PHP + DWZ as the website background. find this code on the Internet and try again, however, I want to add a condition caidselect & nbsp; id, u_id, u_name, last_logintim to ask the DWZ PHP website background page change question.

This post was last edited by gdljw at 11:45:59

Finally, let's use PHP + DWZ as the website background. find this code on the internet. if the trial is normal, you can change the page. However, I want to add the condition caidid = caidid pagination, directly at $ 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 }";

The page cannot be changed. how can I set it?

 Require_once '../include/config. php ';
$ Connect = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD)
Or die ('could not connect to mysql server .');

Mysql_select_db (DB_DATABASE, $ connect)
Or die ('could not select database .');
?>


 Echo '';
// Define a conditional SQL statement

$ CateId = get_CateId_by_UId ($ UId );
$ Tiaojian = empty ($ _ POST ["tiaojian"])? 'U _ name': $ _ POST ["tiaojian"];
$ Neirong = empty ($ _ POST ["keywords"])? "": $ _ POST ["keywords"];
$ CateId2 = empty ($ _ POST ["CateId2"])? 'Cateid': $ _ POST ["CateId2"];
$ OrderField = empty ($ _ POST ["orderField"])? "Id": $ _ POST ["orderField"];
$ Query = mysql_query ("select * from users ");
$ TotalCount = mysql_num_rows ($ query );
$ PageNumShown = 10;
$ _ POST ["pageNum"]! = ""? $ PageNum = $ _ POST ["pageNum"]: $ pageNum = 1;
$ NumPerPage = empty ($ _ POST ["numPerPage"])? 20: $ _ POST ["numPerPage"];
$ Fup_page = ($ pageNum-1) * $ numPerPage;
$ 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 }";
$ Result = mysql_query ($ SQL );
?>