20 posts per page

[madddidley]

Does anyone know where I could find a script that creates a new page for my guestbook after there are 20 posts on the page.

www.madddidley.com

[Conor]

try searching google for pagination, should come up with what you need

[ShrineDesigns]

if you are using mysql (or similar database) to store your guest book entries in, you could do something like this:<?php
$per_page = 20;

function pg()
{
return (isset($_GET['pg'])) ? $_GET['pg'] : 1;
}
$link_id = mysql_connect($server, $username, $password);
mysql_select_db($database, $link_id);
$result = mysql_query("SELECT * FROM `table` LIMIT ".(pg() - 1) * $per_page.", $per_page", $link_id);

while($row = mysql_fetch_array($result, MYSQL_NUM))
{
//process each row...
}
?>

[madddidley]

Would I put that function after the piece of code that actually adds it to the database?



www.madddidley.com

[ShrineDesigns]

a function must exist before you can use it

[Nevermore]

Since PHP parses the file first, you should be able to put functions anywhere in the file and still reference them.