title: How to write PHP code to go through records one at a time?
body: <p>So I'm new to php/mysql.  I am testing with a very small database (single table with only 10 records) as I'm just trying to learn.  </p>
  
  <p>I'm displaying the following result on a php page: select * from mytable where city = "atlanta" </p>
  
  <p>It works.. the result shows up on my page.  Now, I'm wondering, how can I put a link under this record that says "show next result" and on clicking it, it simply pulls up a new page with the next result in my database?  </p>
  
  <p>Does this require a whole pagination script or is there a simple way?  </p>
  
  <p>Thanks! </p>