$limit=20; // 每页显示的行数 $numresults=MySQL(和PHP搭配之最佳组合)_query("select * from TABLE where YOUR CONDITIONAL HERE order by WHATEVER");//换成你所需要的sql语句 $numrows=MySQL(和PHP搭配之最佳组合)_num_rows($numresults);
// next determine if offset has been passed to script, if not use 0 if (empty($offset)) { $offset=1; }
// 得到查询结果 $result=MySQL(和PHP搭配之最佳组合)_query("select id,name,phone ". "from TABLE where YOUR CONDITIONAL HERE ". "order by WHATEVER limit $offset,$limit");
// 现在显示查询结果 while ($data=MySQL(和PHP搭配之最佳组合)_fetch_array($result)) { // 在这里插入您要显示的结果以及样式 }
// 显示按钮
if ($offset!=1) { // bypass PREV link if offset is 1 $prevoffset=$offset-20; print "上一页 \n"; }
// $pages now contains int of pages needed unless there is a remainder from pision if ($numrows%$limit) { // has remainder so add one page $pages++; }
for (&#36;i=1;&#36;i<=&#36;pages;&#36;i++) &#123; // 显示页数 &#36;newoffset=&#36;limit*(&#36;i-1); print "&#36;i \n"; &#125;
// check to see if last page if (!((&#36;offset/&#36;limit)==&#36;pages) && &#36;pages!=1) &#123; // not last page so give NEXT link &#36;newoffset=&#36;offset+&#36;limit; print "下一页