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