while pagination

[Hypertext]

<?php
$sql = "SELECT * FROM NEWS";
$query = mysql_query($sql);

$total = mysql_num_rows($query);
$maxnews = 3;
if($total <= $maxnews)
{
//what do i put here??????
}
else{
while($result = mysql_fetch_array($query)) {
// echo news articles if total is no greater than 3
}
}
?>


what do I put there?

[Hypertext]

I assume I would need to echo the top 3 articles, ordering by id ascending but how would I only display the page number once at the bottom, and calculate the pages...

[DJ-Vimto]

im no genius when it comes to php...but im sure that the parts in orange are simply 'comments' for the writer of the script, and that they play no part in the execution of the script or function

[RedCrisps]

Yeh, there just comments =)

[Hypertext]

I put the echoing articles bit, because I can do that, and the other bit to signify where and what I need help with.

[Navicat]

That is not the way you do pagination. ;)

http://php.about.com/od/phpwithmysql/ss/php_pagination.htm

[Hypertext]

Can you put this chunky text you directedme to into a small literary cycle. :)

[Ivake]

Test the divs and found out

[Hypertext]

Ivake, your theJOSH I know it, and sthu. Try doing this yourself, oh wait you can't.

[Hypertext]

Did it, close t.