I know I can do this in code, but was wondering if I am overlooking something in the docs about it.
Table images --------------- Id url Currently, I show a simple list on a page where one can click on the image and it pops open a new window and loads url as a img src. I have been asked to add in prev | next links at the bottom of the pop up window. I was thinking I can do a select id from images to get a list of all the id's and use some code to create the proper links, if I am at the last link, I can wrap to the first one and vice versa. Is perhaps there some way to get the next id and prev id in a mysql query based on id being sorted? -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
