Quote:
|
Originally Posted by johno
It works fine but my problem is when results are shown I want to use the pagination feature. Like 10 results per page.
|
Pass two additional variables - offset and results. 'Offset' will tell you when to start the result and 'page' would tell you how many to retrieve:
Quote:
|
mysql> SELECT * FROM table LIMIT 5,10; # Retrieve rows 6-15
|