[SOLVED] accessing next record

[jcombs_31]

I have a database in which the primary key auto increments for each new record.  I have a gallery that needs to have a left/right button to access the next image.  There is a possibility that a record was deleted, which means increasing a counter by 1 could come up empty.  What is the best way to handle this?  I want to simply move to the next availabe record based on the id.  I could do a check to see if the record exists, but I would think there would be something even easier to account for this.

[arianhojat]

the next row.

pretend row currently is row=5

then SELECT rowID from theTable WHERE rowID > 5 LIMIT 1

should get next highest rowID by getting all rows higher than 5, but only pulling 1st row.

 

if returns a row, then put a button, if doesnt, dont include Next Image button.

[jcombs_31]

makes sense, thanks.

[skyer2000]

What would you need to do so that once it no longer finds a Next Record, it loops back to the beginning?

[fenway]

You'd have to find the first record, which, according to this psuedo-sortorder, is probably ORDER BY rowID ASC LIMIT 1.