PDA

View Full Version : Creating Pages for info that is in a do while loop


2bz2p
06-24-2008, 01:58 PM
Hi,

So I am looking for a start point basically, this is what I got so far.

I have a do while loop that creates a table of all the pilots (like a pilot roster) and right now I have 7 pilots, so my question is where do I start to create say 3 Pilots per page so ultimately it would give me 3 pages of pilots?

Thanks
2b

edbr
06-25-2008, 01:14 AM
pagination i would say.

2bz2p
06-25-2008, 02:39 AM
pagination i would say.

I was thinking about this earlier, I think I got it, but its not written yet, but basically use the address bar and pass the variables I need, I get what that means now! :-D

edbr
06-25-2008, 03:04 AM
i would think you could also use limit 1,3 and limit 4,.6 on you seperate select statements if you want static pages

davidj
06-25-2008, 06:12 AM
Yes

LIMIT is your friend here

http://www.php-mysql-tutorial.com/php-mysql-paging.php

2bz2p
06-25-2008, 11:50 AM
Cool Thank you all for the replies and I think I got it especially with the help of that tutorial.

Thanks again
2b