Jump to content


Photo

Creating different pages for database values?


  • Please log in to reply
2 replies to this topic

#1 Solarpitch

Solarpitch
  • Members
  • PipPipPip
  • Advanced Member
  • 708 posts
  • LocationDublin, Ireland

Posted 19 October 2006 - 03:44 PM

Hey,

I was wondering how you can create a page that displays information with an option to flick to the next page? What I mean is:

If I need to pull 100 values from the database and I only want to show 20 values per page? Like this forum its show's x numbers of values but has like 300 pages?

EG: page 1 of 300  [1] 2 3 4 5 . . .

cheers?
Welcome to 9AM Monday, the furthest point away from 5PM Friday.

#2 HuggieBear

HuggieBear
  • Members
  • PipPipPip
  • Advanced Member
  • 1,899 posts
  • LocationEngland, UK

Posted 19 October 2006 - 03:52 PM

What you're talking about is pagination and there's a tutorial on this site in the tutorials section.

Regards
Huggie
Advice to MySQL users: Get phpMyAdmin and test your queries work there first, take half the hassle out of diagnosis, also check the reserved words list.

Links: PHP Docs :: RegEx's :: MySQL :: DevGuru :: w3schools

#3 Solarpitch

Solarpitch
  • Members
  • PipPipPip
  • Advanced Member
  • 708 posts
  • LocationDublin, Ireland

Posted 19 October 2006 - 04:01 PM

Thanks for that man!
Welcome to 9AM Monday, the furthest point away from 5PM Friday.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users