i need help to query my image gallery database for the batch of images that i imported last (like in iphoto).
i have a column called date_import with the type of date that contains the dates of all the images that i have imported.
in pseudo-code it may be something like this:
SELECT * FROM images_tbl WHERE date_import is nearest today;
i think that would always give me the last set of images i imported whether its two days ago or a month.
but that will only show me the last image.
i need to show the last batch of images.
i use this in iphoto all the time. the reason i find it handy is because when i come home from a holiday or some event and i empty my camera, it may take weeks before i sort all of them into different albums and such. so by using last import i won't put images that are already there into the albums.