Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Determine relative record number of a table row

relative record number

11:00 am on Jun 26, 2010 (gmt 0)

Junior Member

10+ Year Member

joined:May 1, 2004
posts: 104
votes: 0

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.