Re: Site Map and Page-o-mation

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 thumbnail images and then the next web page is made. I use page-o-mation to offer the subsequent pages for photos that are of similar content. The code below is what I have come up with so far. Where I am stuck is determining the most recent photo_gallery_index.last_update value for the up to 18 photos thumbnails which are being displayed.

select * from table order by last_update_time desc limit 18; -- Postgresql & php tutorials http://www.designmagick.com/