PHP中实现SELECT结果分页显示

假设表的名称为A,记录条数据为未知.
各个问题最好用一条SELECT 实现
1.取出表中前10条记录.(按物理逆序又应如写)
2.取出表中的后10条记录.(按物理逆序又应如写)
3.取出表中第10条到第20条记录.(按物理逆序又应如写)
4.取出表中的所用记录,并加上两列分别是行号及物理行号.
---------------------------------------------------------------

1、select * from a limit 0,9
2、select top(10) from a order by id desc
3、select * from a limit 9,19
---------------------------------------------------------------

CREATE TABLE sort ('Col1' INT (3) UNSIGNED NOT NULL, 'Col2' CHAR (1) NOT NULL, PRIMARY KEY (Col1),INDEX Col2 (Col2));
INSERT INTO sort (Col1, Col2) VALUES (1, 'A');
INSERT INTO sort (Col1, Col2) VALUES (2, 'C');
INSERT INTO sort (Col1, Col2) VALUES (3, 'B');
INSERT INTO sort (Col1, Col2) VALUES (4, 'D');
INSERT INTO sort (Col1, Col2) VALUES (5, 'F');
INSERT INTO sort (Col1, Col2) VALUES (6, 'E');
INSERT INTO sort (Col1, Col2) VALUES (7, 'H');
INSERT INTO sort (Col1, Col2) VALUES (8, 'G');
INSERT INTO sort (Col1, Col2) VALUES (9, 'K');
INSERT INTO sort (Col1, Col2) VALUES (10, 'J');
INSERT INTO sort (Col1, Col2) VALUES (11, 'L')
INSERT INTO sort (Col1, Col2) VALUES (12, 'I');
INSERT INTO sort (Col1, Col2) VALUES (13, 'N');
INSERT INTO sort (Col1, Col2) VALUES (14, 'M');

SELECT * FROM Table1 Limit 0,10;
#按物理顺序取前10个

SELECT * FROM Table1 Limit 10,10;
#按物理顺序从第10开始取10个

取后几个，要先查询了总记录数
SELECT Count(*) As Count FROM Table1;
然后在自己程序里处理成如上所示的SQL

至于按物理顺序逆序取，
呵呵，
：《

---------------------------------------------------------------

$sql = "select cardid,company,name from namecard where";
......

$sql .= " limit $offset,10";
$result2 = mysql_query($sql);
while ($row = mysql_fetch_array($result2))

{
show_card($row);
}
$pages = ceil($num/10);
echo "

 1<tr bgcolor="#ffffff"><td align="center" colspan="5">";   
 2echo "(共{$pages}页)\n\n\n";   
 3if($offset&gt;=10) //$offset大于9，在第二页面以上就会显示前一页   
 4{   
 5$preoffset = $offset-10;   
 6echo "<a href='\"$PHP_SELF?status=$status&amp;offset=$preoffset\"'>前一页</a> \n";   
 7}   
 8  
 9for ($i=1; $i &lt;= $pages; $i++)   
10{   
11$newoffset=10*($i-1);   
12echo "<a href='\"$PHP_SELF?status=$status&amp;offset=$newoffset\"'>[$i]</a> \n";   
13  
14}   
15if ($pages!=0 &amp;&amp; ($offset/10+1)&lt;$pages)   
16{   
17echo "<a href='\"$PHP_SELF?status=$status&amp;offset=".($offset+10)."\"'>下一页</a> \n";   
18}   
19echo "</td></tr>

";

}