Re: [PHP-DB] Site Map and Page-o-mation

2008-11-13 Thread Ron Piggott
Chris I had tried this solution before I e-mailed the list. It didn't work, the image filenames are sequential order ( 1.JPG, 2.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

[PHP-DB] Site Map and Page-o-mation

2008-11-12 Thread Ron Piggott
I need help with a site map I am making using PHP. The site map is of an online photo gallery. In the code below I am trying to determine the lastmod value for the photo theme (category) thumbnail image pages. Each of the photo theme (category) pages may display up to 18 thumbnail images and

Re: [PHP-DB] Site Map and Page-o-mation

2008-11-12 Thread Chris
Ron Piggott wrote: I need help with a site map I am making using PHP. The site map is of an online photo gallery. In the code below I am trying to determine the lastmod value for the photo theme (category) thumbnail image pages. Each of the photo theme (category) pages may display up to 18

Re: [PHP-DB] Site Map and Page-o-mation

2008-11-12 Thread Ron Piggott
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 =

Re: [PHP-DB] Site Map and Page-o-mation

2008-11-12 Thread Chris
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 =