master detail page - move specific record detail page

I am trying to create a master/detail page set whereby I can click on a link on the master page and go to a detail page to display more detail of that record.

I have acheived this without problem.

However, what i need is to be able to page through the detail page as well, instead of just filtering the recordset on the one item.

I have now built the master and detail pages with identical recordsets.

I need to know how to make the detail page 'move' to the correct position in the recordset, when the corresponding item is clicked on the master page.

I'll be passing an url parameter called 'itemid'.

Any help would be greatly appreciated. Including advice on a different approach if i am misguided in my effort and there is a better approach.

Thanks,

Ben

you need to use 2 recodsets

one to look up the previous record, the other to lookup the next record.

rsPrevious:
SELECT * FROM tableName WHERE idColumn < paramID ORDER BY idColumn DESC LIMIT 1
Variables:
Name: idColumn
type: Integer
Default Value: -1
Runtime value: $_GET['itemid']

rsNext
SELECT * FROM tableName WHERE idColumn > paramID ORDER BY idColumn DESC LIMIT 1

Variables:
Name: paramID
type: Integer
Default Value: -1
Runtime value: $_GET['itemid']

I've been battling away with this all morning.
Could you take another look at your solution and let me know if this would work if my products are not sorted by their itemid on the master page?

I'd like to know before I carry on trying to get the solution to work.

If this will work when master page is sorted by something other than itemid, can you let me know if i need more than the two recordsets you mentioned? And what they are. (presumably a 'current item' recordset. Would that be filtered on 'itemid')

Thanks for any help you can give.

Ben

the recordsets go on the details page, so the sorting on the master page will have no bearing on them.

Thanks for your reply.
The detail page set must be sorted in the same order as the master page set, so that when the user clicks 'next item' on detail page, it will correspond with the next item that they saw on the master page? Am i missing something here?

Also, could you let me know if i need more than the two recordsets you mentioned? And if so, what they are. (presumably i need a 'current item' recordset. Would that be filtered on 'itemid')

Apologies for all the questions.

Ben

You can use any ordering you like, as long as it is consistent in all your recordsets.

  (presumably i need a 'current item' recordset. Would that be filtered on 'itemid')  

I would have thought you already had the current item recordset. the current item recordset would be:

rsCurrent
SELECT * FROM tableName WHERE idColumn = paramID ORDER BY idColumn

Variables:
Name: idColumn
type: Integer
Default Value: -1
Runtime value: $_GET['itemid']


NOTE: I noticed a problem in the original recordsets, i have updated them.

I have successfully got this working when the recordsets are sorted by a unique column (itemid for example). But when i try and do same, with recordsets sorted by price (where a number of same items can have same price), it is not working.

I've spent the afternoon trying to work out how to make it work. I am stumped.

Ben

I'll need to troubleshoot directly, see the private message section.

private message posted

your links where set to point to:
test_detail.php

instead of:
test_detail_price.php