title: MySQL Next/Previous Record
body: <p>What's the best solution to do this:</p>
  
  <p>I've got a query (e.g. <code>SELECT * FROM products WHERE category = 12 ORDER BY price DESC</code>) and the user clicked on one of the products returned by this query. </p>
  
  <p>So in this example the query returns the products 1,3,7,4,10,6,8,9 and 15. The user clicks on product <code>10</code>. Now I want an "next" and a "previous" link to product 6 and to product 4.</p>
  
  <p>How can I get those two ID's ?</p>