mysql - Find page of result record in pagination
imagine that we use pagination to split and display a mysql result like
this, sorted on auto inceremental ID and date:
SELECT name FROM members ORDER BY id DESC, date DESC LIMIT $start, $len
we display that result and page navigation links below it using php.
how we can find that record ID number x is in which page of that result so
we set page number to that page and display that page and end-user do not
need to click navigation and find it?
No comments:
Post a Comment