Pagination issue

[AlamoMelt]

I'm having a pagination problem with an artist's portfolio site I'm working on.
I'm using PHP/MySQL and Dreamweaver MX 2004. Each page has navigation that is
generated from the database. Each page displays a given number of links to
specific art, 5 for instance. When the database has 10 entries, a 'Next' link
will display, and the viewer can then view the 6-10 images. The problem I'm
having is that I need to pass the fact that the viewer is on page 2 (of
results) in the link to the art image. Currently, if they click a link on the
second set of resluts, the image will display, but the navigation will reset to
the first 5 entries. You can see the problem at
[url]http://www.beckytomato.com/drawings.php[/url] I understand that this is something I
could/should do with session variables, but I'm not finding good tutorials
about how to do that in Dreamweaver.

[Duncan Ellwood]

I think that you need to append the urls for your links with the relevant
information regarding the pagination. Currently your links simply provide a
recordID to pull up the image presumably? e.g.

[url]http://www.beckytomato.com/drawings.php?recordID=3[/url]

this is fine but as you say it wont provide the information for the PHP to
paginate your records properly so what you would need is some code to work
this out and append the links accordingly. The links SHOULD be something
like this:

[url]http://www.beckytomato.com/drawings.php?pageNum_bottomNav=1&totalRows_bottomN av=11&recordID=3[/url]

So in other words you pass the variables pageNum_bottomNav in this case 1
AND totalRows_bottomNav in this case 11 AND the image recordID.

To build the links dynamically I suppose something along the lines of this
would do

if(isset($_GET['totalRows_bottomNav'])){
// The var totalRows_bottomNav has been set in the url for this
page so we need to modify the links accordingly
$url = "http://www.beckytomato.com/drawings.php?recordID=3"; // The orig
url for the link
$url .= "&totalRows_bottomNav=" . $_GET['totalRows_bottomNav']; // Append
with the totalrows var
$url .= "&pageNum_bottomNav=" . $_GET['pageNum_bottomNav']; // Append the
pageNum var
}

So the final url for this example SHOULD read
[url]http://www.beckytomato.com/drawings.php?recordID=3&totalRows_bottomNav=1&page Num_bottomNav=11[/url]


I havent tested the above code and its late in England now but it should
hopefully give you an idea as to where the problem lies and how to fix it:)
There are numerous ways to achieve this and this was just a quick example -
I hope this helps!


"AlamoMelt" <webforumsuser@macromedia.com> wrote in message
news:cv3d6p$qpp$1@forums.macromedia.com...

> I'm having a pagination problem with an artist's portfolio site I'm
> working on.
> I'm using PHP/MySQL and Dreamweaver MX 2004. Each page has navigation
> that is
> generated from the database. Each page displays a given number of links to
> specific art, 5 for instance. When the database has 10 entries, a 'Next'
> link
> will display, and the viewer can then view the 6-10 images. The problem
> I'm
> having is that I need to pass the fact that the viewer is on page 2 (of
> results) in the link to the art image. Currently, if they click a link on
> the
> second set of resluts, the image will display, but the navigation will
> reset to
> the first 5 entries. You can see the problem at
> [url]http://www.beckytomato.com/drawings.php[/url] I understand that this is
> something I
> could/should do with session variables, but I'm not finding good tutorials
> about how to do that in Dreamweaver.
>

[AlamoMelt]

Thank you very much!

I was able to get in running in about 2 minutes because of your help.