jcombs_31 Posted February 16, 2007 Share Posted February 16, 2007 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. Quote Link to comment Share on other sites More sharing options...
arianhojat Posted February 16, 2007 Share Posted February 16, 2007 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. Quote Link to comment Share on other sites More sharing options...
jcombs_31 Posted February 16, 2007 Author Share Posted February 16, 2007 makes sense, thanks. Quote Link to comment Share on other sites More sharing options...
skyer2000 Posted March 9, 2007 Share Posted March 9, 2007 What would you need to do so that once it no longer finds a Next Record, it loops back to the beginning? Quote Link to comment Share on other sites More sharing options...
fenway Posted March 9, 2007 Share Posted March 9, 2007 You'd have to find the first record, which, according to this psuedo-sortorder, is probably ORDER BY rowID ASC LIMIT 1. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.