timjpriebe — Tue, 23 May 2006 19:53:08 +0000

No problem. Looking good so far!

saxman13ga — Tue, 23 May 2006 18:48:11 +0000

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 — Tue, 23 May 2006 18:16:31 +0000

Not a problem. Let us know how it turns out. I'd love to see the link once you've modified it.

saxman13ga — Tue, 23 May 2006 17:38:27 +0000

That makes a lot of sense.

Thanks for the help!

timjpriebe — Tue, 23 May 2006 16:11:05 +0000

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?