Displaying MySQL Data with PHP

[berbbrown]

Hi All

I have a results PHP page which returns a list of products based on some initial fields selections. The list returned is also displayed randomly. This works fine.

My problem is that I want to implement some navigation buttons to move forward/backwards etc and restrict the number of products displayed on a page. I CAN DO THIS.

My Question is, "how can ensure that when I move forward, either one or more pages, my original sorted list is used rather requerying the list to advance through the data?"

I though about using LIMIT x, y as part of the SQL Query, but I am uncertain about how I can maintain the initial sorted list.

Can anyone help please?

Thanks

BB

[sarahk]

because the list is randomised you will need to save the results in the sesssion. Then when the user clicks back or next you just use the session data.