Chris I had tried this solution before I e-mailed the list. It didn't work, the image filenames are sequential order ( 00001.JPG, 00002.JPG, etc.) I have simply decided to put the most updated images showing on the first page of thumbnails by reversing the ORDER BY to have the date field first and file name second. Thanks for your input. Ron On Thu, 2008-11-13 at 15:30 +1100, Chris wrote: > Ron Piggott wrote: > > This doesn't take into account the page - o - mation though. > > > > The query that determines which up to 18 images display on the > > thumbnails page is: > > > > SELECT * FROM photo_gallery_category INNER JOIN photo_gallery_index ON > > photo_gallery_index.photo_gallery_category_reference = > > photo_gallery_category.reference WHERE > > photo_gallery_category.category_name = '$photo_gallery_category' ORDER > > BY photo_gallery_index.filename ASC LIMIT " . ( ($page*18) -18) . " , 18 > > > > I see where you are coming from Chris. What I need to know is from the > > 18 images which has the most recent last_update value. I need the site > > map to match what is being displayed on the thumbnails page. > > You can order by two fields. > > order by filename asc, last_update_time desc limit ... > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
