I have a list of records that I want to page through using LIMIT however the first record that is returned without LIMIT is also the root identifier for the rest of the records and I need to keep it for every page. Is this possible? (I would just prefer not to run a extra sql statement)\[code\]id | index | title1 | 0 | index of titles2 | 1 | title13 | 1 | title24 | 1 | title35 | 1 | title4\[/code\]LIMIT 3, 2 should return...\[code\]id | index | title1 | 0 | index of titles4 | 1 | title35 | 1 | title4\[/code\]
mysql/php: keeping an extra record while paging
- Thread starter lee91
- Start date