Using select_min()

[eluser]sore eyes[/eluser]
hi cfraz, thanks for responding. 'shop' is the name of the table, rather than shop_id which is the name of a field, so changing it does not work.

What I want to do is show the details of each record on one page and to be able to cycle through them, using buttons 'goFirst', 'goNext', 'goPrevious' and 'goLast'. So I thought of using the id of each record for this. Using 'limit' of 1 works for the first record, but it cannot be used for the other records.