mysql> select count(document_id) from document;
+--------------------+
| count(document_id) |
+--------------------+
| 36 |
+--------------------+
1 row in set (0.13 sec)
mysql> select document_id from document;
+-------------+
| document_id |
+-------------+
| 31 |
| 32 |
| 36 |
| 37 |
| 38 |
| 39 |
| 40 |
| 41 |
| 42 |
| 43 |
| 44 |
| 45 |
| 46 |
| 53 |
| 54 |
| 55 |
| 56 |
| 57 |
| 58 |
| 59 |
| 60 |
| 61 |
| 62 |
| 101 |
| 102 |
| 244 |
| 245 |
| 283 |
| 284 |
| 296 |
| 297 |
| 305 |
| 306 |
| 310 |
| 318 |
| 319 |
+-------------+
36 rows in set (0.01 sec)
mysql> select document_id from document where document_id < 60;
+-------------+
| document_id |
+-------------+
| 31 |
| 32 |
| 36 |
| 37 |
| 38 |
| 39 |
| 40 |
| 41 |
| 42 |
| 43 |
| 44 |
| 45 |
| 46 |
| 53 |
| 54 |
| 55 |
| 56 |
| 57 |
| 58 |
| 59 |
+-------------+
20 rows in set (0.00 sec)
mysql> select document_id from document where document_id < 60 limit 0
+,4;
+-------------+
| document_id |
+-------------+
| 31 |
| 32 |
| 36 |
| 37 |
+-------------+
4 rows in set (0.00 sec)
mysql> select document_id from document where document_id < 60 limit 4
+,4;
+-------------+
| document_id |
+-------------+
| 38 |
| 39 |
| 40 |
| 41 |
+-------------+
4 rows in set (0.00 sec)
mysql> select document_id from document where document_id < 60 limit 8
+,4;
+-------------+
| document_id |
+-------------+
| 42 |
| 43 |
| 44 |
| 45 |
+-------------+
4 rows in set (0.00 sec)
mysql> select document_id from document where document_id < 60 limit 1
+2,4;
+-------------+
| document_id |
+-------------+
| 46 |
| 53 |
| 54 |
| 55 |
+-------------+
4 rows in set (0.00 sec)
mysql> select document_id from document where document_id < 60 limit 1
+6,4;
+-------------+
| document_id |
+-------------+
| 56 |
| 57 |
| 58 |
| 59 |
+-------------+
4 rows in set (0.00 sec)
mysql> select document_id from document where document_id < 60 limit 2
+0,4;
Empty set (0.00 sec)
So... if $pagenum starts at 0, that's 'limit $pagenum*$maxperpage, $maxperpage'
Your SQL may vary.
|