title: JavaScript/jQuery to load more from MySQL?
body: <p>I searched Google on how to do this, and I got the following link:
  <a href="http://www.9lessons.info/2009/12/twitter-style-load-more-results-with.html" rel="nofollow">http://www.9lessons.info/2009/12/twitter-style-load-more-results-with.html</a></p>
  
  <p>That is exactly what I want to do, however it's rather confusing to me so I can't work out how to implement it properly to my current file.</p>
  
  <p>My current query is as follows.</p>
  
  <pre><code>if (!$query = @mysql_query("SELECT * FROM confessions ORDER BY date DESC LIMIT 10")) {
      echo '&lt;strong&gt;Error:&lt;/strong&gt; '.mysql_error().'';
  } else {
      echo '&lt;div id="posts"&gt;';
      while ($q = mysql_fetch_array($query)) {
          $id = $q['id'];
          $name = $q['confession'];
          $date = date("j M Y", strtotime($q['date']));
          echo '&lt;div class="confession" ';
          echo '&gt;';
              echo '&lt;table&gt;';
                  echo '&lt;tr style="width:700px;"&gt;';
                      echo '&lt;td style="width:100px;font-weight:lighter;font-style:italic;font-size:95%;"&gt;'.$date.'&lt;/td&gt;';
                      echo '&lt;td style="width:600px;"&gt;'.$name.'&lt;/td&gt;';
                  echo '&lt;/tr&gt;';
              echo '&lt;/table&gt;';
          echo '&lt;/div&gt;';
      }
      echo '&lt;/div&gt;';
  }
  </code></pre>
  
  <p>Obviously that just grabs the data of the last 10 rows in that table, and as far as I know I just need some JavaScript to remember the limit, and how many it grabbed, so it can grab the next lot.</p>
  
  <p>Is it possible somoene can give me a link to help me explain it more, or write up some code (from the link I gave) that'll help?</p>