Re: LIMIT/OFFSET to paginate results

2009-11-23 Thread Brent Baisley
The order the records are returned is not guaranteed unless you specify an ORDER BY. You could run the same query multiple times and the order the records are returned could be different each time. Although this is rarely the case, especially with caching enabled. Always do an ORDER BY with p

Re: LIMIT/OFFSET to paginate results

2009-11-23 Thread Martijn Tonies
Hello list :) I am developing an application that will show records in paginated documents, i.e. 10 records per page Lets supose this row structure MyTable ID(autoincrement) SectionID Name Description The ID is automatic autoincrement for unique records, the SectionID is to separate i