Re: Site Map and Page-o-mation

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

Ron

On Thu, 2008-11-13 at 14:28 +1100, Chris wrote:
> 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;
> 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux