title: Query to fetch more rows to append to currently fetched rows using time() function timestamp. MySQL/PHP
body: <p>This is my current query to fetch the last 10 rows that were added into the table based on the time.</p>
  
  <pre><code>$query = $pdo-&gt;prepare("SELECT * FROM bracket ORDER BY bracket_time DESC LIMIT 10");
  </code></pre>
  
  <p>And I want my site to load more data when the user scrolls down (10 extra rows). So I've been thinking of a query that I could do, that would load more rows to append to the currently loaded rows. But the only solution I've been able to come up with is doing something like this, but I don't know if that's the best way to go about it:</p>
  
  <pre><code>$query = $pdo-&gt;prepare("SELECT * FROM bracket WHERE bracket_time &lt; '$_GET['last_bracket_time']' ORDER BY bracket_time  DESC LIMIT 10");
  </code></pre>
  
  <p>I was wondering if there was another way to go about it? Also here's a picture of my table
  <a href="http://i.imgur.com/C5q76Az.png" rel="nofollow">http://i.imgur.com/C5q76Az.png</a></p>
  
  <p>PS: The second query might have syntax errors I just made it as an example, I'm still learning mysql queries so don't mind any syntax. Thanks.</p>
  
  <p>PPS: Should I maybe make another field that auto increments for each row added and use that for my queries? </p>