[RESOLVED] Mysql select (selecting next 5 rows starting from already selected)

[2005]

Table "images" contains information about images of the photo gallery.
"Id" column contains unical numbers of images:
2
3
9
30
56
87
92
96
100

I need a script which shows selected image and thumbs of next 3 images. For example, if script displays image with id "9", next three thumbs will be: 30, 56, 87. The question is about mysql query - in this example the query should select 3 rows starting from id "30".

SELECT file FROM images where approved='1' order by id desc limit ??????, 3

I hope you can understand my question.

Thanks.

[Piranha]

select something from somewhere where id > $oldid order by id asc limit 0,3

or

select something from somewhere order by id asc limit $oldcount, 3

[2005]

Piranhaб, thank you very much!
It's so easy with where id > $oldid , but I was looking for complicated solution 🙂