This may have been answered before.

[Anon]

Hey I am soo sorry if this has been answered before. I just don't even know what to look up to find my answer. I am looking to have a pictures page where 10 pictures will come up and then if there are more than 10 then it will create another page. Like lets say there is 36 pictures. There should be 3 full pages and the fourth page has 6 on it. All the pictures are listed in the database (i.e. pic1.jpg, pic2.jpg) the file names are. They all have their own seperate rows also...some will have descriptions but please do not worry bout those. I know the Limit statement but can I use it to do this or is there something I am missing? Thank you very much and have a great rest of the day! Thanks again!

Chad R. Smith
President of Brokenformula
www.brokenformula.com

[Anon]

yes, you can use limit (mysql) for this.

for paging (= your goal), you need a start and an offset value. by default (if the script has none set), start=0 and offset=10.
select the records (pics) from the database using these values as parameters for limit.

then, your script must generate a BACK and a FORWARD link on the bottom of the page, the references being:

BACK: script.php?start=[current start value minus offset]&offset=[offset]
FORWARD: script.php?start=[current plus offset]&offset=[offset]

of course, you would like to refine this later on. so you wouldn't provide a back link on the very first page and a forward link on the last one etc ...

in addition to that, you can change the offset value.

hth!