I'm working on an image gallery that uses MySQL to store the URL's and information of images.
Right now, it shows all the images in the gallery on one page and I was trying to figureout how to split them into multiple pages.
Like: show image 1-10 on page 1, then image 11-21 on page 2 ect.
If anyone could give me any help on how to do this, that would be awsome,
Thanks!
timjpriebe posted this at 16:11—23rd May 2006.
He has: 2,666 posts
Joined: Dec 2004
You might do something like this (pseudo-code).
numperpage = 10;page = urlparameter_page;
numtoskip = numperpage * (page - 1)
SQL = "select * from images limit numtoskip, numperpage";
execute(SQL);
if (page != 1)
{
prevpage = page - 1;
pagelink = '<a href="thisfile.php?page=' . prevpage . '>Previous</a>';
}
tempnumtoskip = numtoskip + numperpage;
tempSQL = "select * from images limit tempnumtoskip, numperpage";
execute(tempSQL);
if (any results)
{
nextpage = page - 1;
pagelink .= '<a href="thisfile.php?page=' . nextpage . '>Next</a>';
}
'
Does that pseudo-code make sense?
Tim
http://www.tandswebdesign.com
saxman13ga posted this at 17:38—23rd May 2006.
They have: 16 posts
Joined: May 2006
That makes a lot of sense.
Thanks for the help!
timjpriebe posted this at 18:16—23rd May 2006.
He has: 2,666 posts
Joined: Dec 2004
Not a problem. Let us know how it turns out. I'd love to see the link once you've modified it.
saxman13ga posted this at 18:48—23rd May 2006.
They have: 16 posts
Joined: May 2006
I finished modifying.
You can view the gallery here:
http://www.buschadventure.com/customgall/
Theirs still some modifications to be done, and it's not open to the public yet.
Thanks again for the help!
timjpriebe posted this at 19:53—23rd May 2006.
He has: 2,666 posts
Joined: Dec 2004
No problem. Looking good so far!