Re: [PHP-DB] 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/