MySQL Select / Next 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
zatch
Forum Newbie
Posts: 18
Joined: Fri Jul 02, 2004 7:05 pm

MySQL Select / Next Page

Post by zatch »

Ok ... basically here is what I need (and cant figure out hwo to do)
I want it so data 1-10 is displayed on the PHP page, but then you can click next to see data 11-20, etc ...

All the data is stored on MySQL ... I know about

Code: Select all

SELECT * FROM database LIMIT 10

?>
But am clueless as to how to make a next page that automatically displays next 10 entries.

THANKS!
Zach
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post by markl999 »

Search this site for 'paging' or 'pagination' there's a ton of solutions ;)
zatch
Forum Newbie
Posts: 18
Joined: Fri Jul 02, 2004 7:05 pm

Post by zatch »

THANKS SO MUCH

I was able to find http://www.devarticles.com/c/a/MySQL/Bu ... s-With-PHP which has exactly what i need so if anybody else should need to learn howto page ... check it out
Post Reply