selecting the next entry in mysql

[michaelkenneth]

Hi. I have a page that displays an image. The image path and unix time number are all kept in a mysql database. I can't figure out, how I can pick the the next sql record from mysql that was added before the current one. Does anyone know how I could do this?

[sneakyimp]

if you know the unix time number of your first image and it's defined in the variable $first_time, your query might look something like this:

SELECT * FROM your_image_table WHERE unix_time_number > $first_time LIMIT 1

[michaelkenneth]

thanks to you I got it figured out.