Kidrandom Posted March 14, 2011 Share Posted March 14, 2011 Hey all, I've made a page that reads a list of items from a database and I want it to automatically generate a new page when the amount of items pulled from the database reaches a certain number. Exactly the way the extra pages in this forum are generated once a certain amount of topics are posted on one page. I'm fairly new to PHP and MySQL so I'm finding it difficult to conceptualize how this will work. So my question is, how do I go about doing this? Here's the code I'm using to generate the items: while ($post = mysql_fetch_array($query)) { echo "<div id=\"result_item\">"; echo "<p class=\"result_blue\">"; echo "<a href=\"desc.php?sel_post=" . urlencode($post["id"]) . "\">"; echo $post["job"] . "</a></p>"; echo "<p class=\"dark_grey\">"; echo $post["employer"] . " | " . $post["location"] . " | £" . $post["salary"] . " per " . $post["salary_freq"]; echo "</p></div>"; } Thanks! Quote Link to comment Share on other sites More sharing options...
litebearer Posted March 14, 2011 Share Posted March 14, 2011 The term is PAGINATION - an excellent class is here - http://phpsense.com/php/php-pagination-script.html Quote Link to comment Share on other sites More sharing options...
Kidrandom Posted March 14, 2011 Author Share Posted March 14, 2011 Awesome! Just what the Doctor ordered. Thanks for your help! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.