Splitting content into pages w/ 5 per page

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
joetheeskimo5
Forum Commoner
Posts: 43
Joined: Sun Dec 14, 2003 4:47 pm
Location: US
Contact:

Splitting content into pages w/ 5 per page

Post by joetheeskimo5 »

While designing a page that will display images stored in a MySQL database, I know that I can't just have one big list of images -- I've got about 58 images, with more being submitted every month. How would I split my content into pages, with 5 displayed on each page? What would I put into my SELECT query?
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post by Burrito »

Code: Select all

limit 5
search pagination discussed hundreds of times on this board.
Post Reply