pte

Hi! I am wondering how I can find out the index of a row in a MySql table given a certain order. For example I have a table containing information of some images on my computer. After SELECT * FROM Images WHERE Id=\'12\' ORDER BY Date I get an Image and want to find the next image (next in the Date order). So I would like something as index = GETINDEX FROM Images WHERE Id=\'12\' ORDER BY Date nextimage = SELECT * FROM Images WHERE ORDER BY Date LIMIT index+1, index+1 Someone know how to code this into a proper SQL query? thanks, pieter