Pagination

alex1985

Mar 24 2008, 07:57 AM

People they create the databases in which like the news stories are placed. Then that news stories, they are placed on certain page to be displayed and readable by other users on the web-site. How people do that thing paging, like you can see bottom, whenever, you go to Any CMS engines. Need the concept how you can create, 1, 2 or 3 pages, then next and back buttons, last and beginning page.

darran

Mar 24 2008, 08:17 AM

Basically, it is using the concept of displaying a certain number of records from your database.

This article should help you:
http://www.php-mysql-tutorial.com/php-mysql-paging.php

galexcd

Mar 24 2008, 04:57 PM

Well this question has been brought up plenty of times in the forums. A simple search could have helped you, but here is a quick query to do this for you:

CODE

$resultsperpage=10;
$result=mysql_query("SELECT * FROM content LIMIT ".$_GET['page'].",".$resultsperpage);

alex1985

Mar 25 2008, 03:12 AM

Thanks. That should work, the code looks good. You, two guys, are the one who is good in it, because you always post replies when they are needed.

ADD REPLY / Got an Opinion!	Remove these ADs!	RAPID SEARCH!	Free Web Hosting	[X]
Express your Opinions, Thoughts or Contribute more info. to help others. Ask your Doubts & Queries to get answers, So that "Together We can help others!"	Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.		500MB Space No Ads, CPanel, FTP, PHP, MySQL, EMails - 100% FREE