Saving the MySQL query

[sammy182]

Hello,
This may be a question for the PHP area, but I am not really sure.

You see, what I want to do is this:

• Once the user preforms a search, they click on an item

• After they click on that item, they can click "next item" without going back to the initial search result page.

Can anyone point me in the right direction for this one?

[guelphdad]

that's just pagination really and is PHP related.

[sammy182]

Isn't pagination when you return results and you have the results cut into multiple pages:
Prev 1, 2, 3, 4, 5 Next

What I want to do is to have Prev and Next not on the search results page, but on the item which is displayed. How do you tell MySQL (or PHP) which items would be next in the previous result page?

[Kayzio]

If your items are indexed with ids such as 1,2,3,4,5 then you just write the current item id - 1 for previous item id and current item id + 1 for next item id. This would be the easiest way in my opinion. Just simple math.

[Dan Grossman]

It's the same as pagination with 1 item per page. You just keep reissuing the same query while incrementing the values in the LIMIT clause by 1.

[sammy182]

Kayzio,
The search page will likely output a search with results that do not increment so neatly. A search page my return results: 1, 5, 9, 22

Dan, I think I know what you're saying. When I click on the item, I will have to pass the whole search query again to that page as well. Correct?

[Dan Grossman]

Yes, you'll need to keep track of enough information to execute the same query each time the back/next link is clicked. You'll probably be passing whatever search parameters the user entered. The links will contain the same parameters but a different page number (although you might not call it that); back one less than current, and next one more than current.

[sammy182]

The light bulb just turned on. Thanks for your help!