JavaScript/jQuery to load more from MySQL?
<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>
