PHP Assistance

Posted by leemcd56 on Jan. 1, 2008, 8:26 p.m.

Can anyone explain to me the easiest way to split MySQL data into pages. I have searched all over the web for reasonable tutorials and code snippets but it's all buggy. OK, so maybe it's my way of putting things together, but it's better to ask for help than to wing it.

It's for a journal web site I made. I tried to get it to where it would split the data into a seperate page every 20 entries. However, getting to understand how to paginate with ASP still in mind isn't easy. Any help you can give me? This is the crappy tutorial I got this from: http://www.php-mysql-tutorial.com/php-mysql-paging.php.

Comments

Austin 16 years, 10 months ago
KaBob799 16 years, 10 months ago

I can help

Alert Games 16 years, 10 months ago

Well, what i did for mine is show the results of:

$pageNum*$rowsperpage-$rowsperpage as the minimum value (where row >= that row), and limit of $rowsperpage