php/ mysql - help with pagination

[Tjobbe]

I have created a simple cms and I need to have an archive page that shows ten articles per page, with a "< next | previous >" pagination system or similar.

I have spent a long time away from php, and would dearly love it if somebody could show me how to do it, here is what I have now;

<?php

include "admin/dbconnect.php"; 
include "includes/format_date.php";

$result = mysql_query("SELECT * FROM news ORDER BY id DESC LIMIT 0,5");

//echo's the articles, and even properly indents the code
while($row = mysql_fetch_array($result))
{echo "
<p><em>".$row['shortdescr']."</em></p>
<p>".$row['title']."</p>
<p>".$row['source']."</p>
<p><strong>Posted on:</strong> ".$row['date']."</p>
<hr />
";
}
mysql_close($conn);
?>

[jpease]

Pull your page number into the script and use that to populate your pagination controls and to calculate your "LIMIT" in your SQL query.

[Pistocel]

The idea of pagination is that your code will calculate the maximum number of pages and then on each page will return the query with the LIMIT clause, that is set by the page number.

I wrote a class, it is not OOP it is a beginner class, it is very simple.If you want i will post-it, a search will also help you with this issue.

[Tjobbe]

The idea of pagination is that your code will calculate the maximum number of pages and then on each page will return the query with the LIMIT clause, that is set by the page number.

I wrote a class, it is not OOP it is a beginner class, it is very simple.If you want i will post-it, a search will also help you with this issue.

That would be a real help if you could post it for me, I will search anyway, but I'd already tried that so I'm not hopeful of finding something I can use!

Thanks!

[mmarif4u]

This is simple script u will find it helpful.

http://www.codewalkers.com/c/a/Link-...de/Pagination/

[Tjobbe]

Thank you for the link, I've just found this one too, which works for me: http://www.phpfreaks.com/tutorials/73/0.php