help to select last import

demiurgen · #1 (**permalink**) 08-13-08, 17:07

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.

r937 · #2 (**permalink**) 08-13-08, 17:48

ORDER BY date_import DESC LIMIT 1

demiurgen · #3 (**permalink**) 08-13-08, 18:04

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.

r937 · #4 (**permalink**) 08-13-08, 18:19

Code:

SELECT list of columns
  FROM images_tbl AS table_tbl_t
 WHERE date_import = 
       ( SELECT MAX(date_import) FROM images_tbl)

demiurgen · #5 (**permalink**) 08-14-08, 02:45

AWESOME!
that worked.
but do i have to use the AS table_tbl_t?
it still works without it.

my query is now:
SELECT * FROM albums INNER JOIN images ON albums.id = images.album_id AND date_import = ( SELECT MAX(date_import) FROM images) AND status = 'active' LIMIT 0, 9;