Is there any way to quickly/easily identify the relative record number of a specific table row within a given dataset? Let me to explain…
Using MySQL/PHP, each product page of our website will contains a set of 12 thumbnail images illustrating/linking to other products in the same product group, with pagination links to further pages if there are more than 12 products in that group. The thumbnails are presented in product code order with the currently selected/displayed product thumbnail highlighted. So, products 1 to 12 will always show thumbnails 1 to 12. Page two of the group will always display thumbnails 13 to 24, etc.
Now my question/problem is how to determine which ‘page’ of thumbnails a product is after a user clicks on an image. So, when looking up product “xyz”, how do I determine whether it is on page 1 (row 1-12) or page 2 (row 13-24), etc, of all records for that particular product group.
The stupid thing is that I know the answer is simple, but it is totally escaping me and driving me nuts. I’ve got a total memory block on it. Any pointers will be much appreciated.