title: mysql pagination to display a page with a specific row in it
body: <p>Now I have a question on mysql paging.
  A user's record is displayed on a table with many other user's record. and the table is sorted/paged. 
  Now i need to display the page that containing the user's row directly after the user login. How can I achieve this? 
  A simple thought would be firstly find out the rownum of the user, then do the paging accordingly, but I'm wondering if there are better ways to do it.
  thanks.</p>