pagination

[doddsey_65]

i have some code which checks all of the posts in the database with the topic_id of $topic_id.

 

what i want to do is like on many forums. On the topic list next to the name just show the pages like:

 

1-2-3-4

 

and when there are more than 4 or so

 

1-2....8-9

 

here is the code which gets the number of pages:

 

$data = $db->query("SELECT * FROM
                    ".DB_PREFIX."posts
                    WHERE topic_id = '$topic_info->topic_id'");
$rows = mysql_num_rows($data); 
$page_rows = $posts_per_page; 

if ($rows > $page_rows) {

$rowsArray = array($rows);

}

 

as you can see i have added it into an array but i dont know what to do from there. I guessed it would be something like a for statement but im not sure. Can anyone help?

[pengu]

There are some great tutorials on this website.

Click here : http://www.phpfreaks.com/tutorial/basic-pagination

[xyph]

Please make an attempt before asking us

 

It doesn't have to be code, it could be your though process... possible theoretical solutions.

 

For example: First, I have to figure out how many pages, so I grab the total amount of entries and divide it by entries per page. I then have to check if there are more than 4 pages, and what page the user is currently on... etc