Page 1 of 1

MySQL Select / Next Page

Posted: Thu Jul 08, 2004 7:50 pm
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

Posted: Thu Jul 08, 2004 7:51 pm
by markl999
Search this site for 'paging' or 'pagination' there's a ton of solutions ;)

Posted: Thu Jul 08, 2004 8:09 pm
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