Welcome Guest ( Log In | Register)



 
Reply to this topicStart new topic
> Pagination, ?
alex1985
post Mar 24 2008, 07:57 AM
Post #1


Super Member
*********

Group: [HOSTED]
Posts: 397
Joined: 9-February 08
Member No.: 57,615



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.
Go to the top of the page
 
+Quote Post
darran
post Mar 24 2008, 08:17 AM
Post #2


Privileged Member
*********

Group: Members
Posts: 661
Joined: 31-August 06
From: Singapore
Member No.: 29,189



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
Go to the top of the page
 
+Quote Post
galexcd
post Mar 24 2008, 04:57 PM
Post #3


Define:EVIL PROGRAMMER (ē'vəl prō'grăm'ər)- n. An organism that converts caffeine into evil software.
***********

Group: [HOSTED]
Posts: 1,074
Joined: 25-September 05
From: Los Angeles, California
Member No.: 12,251



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);


This post has been edited by alex7h3pr0gr4m3r: Mar 24 2008, 04:57 PM
Go to the top of the page
 
+Quote Post
alex1985
post Mar 25 2008, 03:12 AM
Post #4


Super Member
*********

Group: [HOSTED]
Posts: 397
Joined: 9-February 08
Member No.: 57,615



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.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Test Your Php Pages W/o Upload/internet(57)
  2. Custom 404 Error Pages(17)
  3. How To: Make A Simple Php Site(21)
  4. Dynamic Php Pages(5)
  5. Data Access Pages ?(1)
  6. Putting Data Of 2 Pages In Mysql At Once(1)
  7. Do You Want To Use Php Code In Your Html Pages?(9)
  8. Adding Accessibility Features To Your Pages(0)
  9. How Do I View My Site?(4)
  10. Pages Not Found?(2)
  11. Still Getting Old Pages(6)
  12. Making Custom Error Pages With Cpanel(4)
  13. How To Get All Pages To Be Indexed(3)
  14. Php Pages Permission On Apache Server(1)
  15. Problem With Firefox, Latest Version, Not Loading Pages(4)
  1. What Is C++ Server Pages?(1)
  2. Php An Js Window.open Pages Trouble.(3)
  3. Pages Url Set Up Problem(5)
  4. Php Pages Problem [resolved](5)
  5. 2 Pages Into One(10)
  6. Site Error For Php Pages(6)
  7. Some Pages On My Site Won't Even Load..(6)
  8. Php--> Content-only Pages(9)
  9. Protect Pages(20)
  10. Simple Javascript And Password System(9)
  11. Create Dynamic Html/php Pages Using Simple Vb.net Code(1)
  12. [aef] Most Recent Topics Listing Mod(2)
  13. Attachment Problem In Pmwiki(0)


 



- Lo-Fi Version Time is now: 11th October 2008 - 11:55 PM