两个设置分页的都出有关问题，想屎了.

两个设置分页的都出问题，想屎了...

<br />&lt;?php<br />$offset = isset($_GET['pid'])?intval($_GET['pid']):1;<br />if(!$offset) $offset = 1;<br />$perpage = 50;<br /><br /><br />$db = NEW PDO("mysql:host=localhost; port = 3306; dbname =library", 'root', 'cai123');<br />$total = $db-&gt;query('SELECT COUNT(*) FROM library.messages')-&gt;fetchColumn(0);<br /><br />$sql = 'SELECT * FROM library.messages'." LIMIT $perpage OFFSET ".($offset-1);<br />$result = $db-&gt;query($sql);<br />if ($result)<br />{<br />  foreach ($result-&gt;fetchAll() as $row)<br />    {<br />       echo "subject:    ".$row[5]."&lt;br /&gt;";<br /> }<br />}<br />else<br />{<br /> $error = $db-&gt;errorInfo();<br />   echo "error happened..".$error[2];<br />  exit();<br />}<br /><br />buildIndex($perpage, $total);//1,50,3500<br /><br />/////////////////////////////////////////////////////////////////<br />function buildLink($index, $offset)<br />{<br />   echo "&lt;a href ='". htmlentities($_SERVER['PHP_SELF'])."?pid = $offset'&gt;$index&lt;/a&gt;";<br />}<br /><br /><br />function buildIndex($perpage, $total)<br />{<br />  $separator = '|';<br />   //buildLink($offset==1, '&lt;&lt;Prev', '')<br /><br /> for ($start = 1, $end = $perpage; $end &lt; $total; $start += $perpage, $end += $perpage)<br />   {<br />       echo $separator;<br />        buildLink("$start-$end", $start);<br />   }<br /><br />   $end = ($total &gt; $start) ? "$total":"";<br />  echo $separator;<br />    buildLink("$start-$end", $start);<br />}<br /><br /><br /><br /><br />?&gt;<br />

另一种思路的.....

<br />&lt;?php<br />$offset = isset($_GET['pid'])?intval($_GET['pid']):1;<br />if(!$offset) $offset = 1;<br />$perpage = 50;<br /><br /><br />$db = NEW PDO("mysql:host=localhost; port = 3306; dbname =library", 'root', 'cai123');<br />$total = $db-&gt;query('SELECT COUNT(*) FROM library.messages')-&gt;fetchColumn(0);<br /><br />$sql = 'SELECT * FROM library.messages LIMIT '. ($offset -1)*$perpage.", $perpage ";<br />$result = $db-&gt;query($sql);<br />if ($result)<br />{<br />    foreach ($result-&gt;fetchAll() as $row)<br />    {<br />       echo "subject:    ".$row[5]."&lt;br /&gt;";<br /> }<br />}<br />else<br />{<br /> $error = $db-&gt;errorInfo();<br />   echo "error happened..".$error[2];<br />  exit();<br />}<br /><br />$numpage = $total%$perpage;<br />if($total%$perpage) $numpage++;<br />$cur = $offset;<br />if ($cur &lt; $numpage)<br />{<br />   echo "&lt;a href ='". htmlentities($_SERVER['PHP_SELF'])."?offset = ".($cur+1)."'&gt; Next Page&lt;/a&gt;&lt;br /&gt;";<br />}<br />if($cur &gt; 0)<br />{<br />    echo "&lt;a href ='". htmlentities($_SERVER['PHP_SELF'])."?offset =". ($cur-1)."'&gt; Prev Page&lt;/a&gt;&lt;br /&gt;";<br /><br />}<br /><br /><br />?&gt;<br />

问题如下：每次点击下一页，或者上一页，显示的都是同样的内容，即首页内容。 当数据表的内容有3000行...是怎么回事啊？
------解决方案--------------------
42 行有 ...setPage02.php?offset=$i'>$i....
而第 2 行是 $offset = isset($_GET['ofset']) ? intval($_GET['offset']) : 1;

知道问题在哪了吧？