Scott Haneda wrote:
[...]
Is perhaps there some way to get the next id and prev id in a mysql query
based on id being sorted?
You could do this using LIMIT. For example:
SELECT id FROM foo WHERE id > $current_id ORDER BY id ASC LIMIT 1;
SELECT id FROM foo WHERE id < $current_id ORDER BY id DESC LI
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 as