MySQL Forums
Forum List  »  PHP

Re: query within query
Posted by: David White
Date: April 06, 2006 05:58PM

Restated -

I want to display only the latest dated statistics for each site where the last taken statistic date varies for each site and display in statistics date order. I don't want to use an array, it must be possible to do this via standard sql. I think I am missing the bleedin obvious.

My query does all but the last bit. I think it is because I am selecting all stats, showing the latest taken statistics date but then trying to order on all the statistics dates rather than just the last one found...

Options: ReplyQuote


Subject
Written By
Posted
April 06, 2006 03:06PM
April 06, 2006 04:28PM
April 06, 2006 05:47PM
Re: query within query
April 06, 2006 05:58PM
April 06, 2006 09:36PM
April 07, 2006 04:48PM
April 07, 2006 06:15PM
April 07, 2006 09:23PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.