List:General Discussion« Previous MessageNext Message »
From:Jigal van Hemert Date:July 29 2005 2:10pm
Subject:Re: MAX select problem
View as plain text  
Lee Denny wrote:
> Hello,
> 
> I'm trying to get the date and amount of the most visits to my site over a
> given time period using :
> 
> SELECT max(visits) as maximum FROM visit WHERE (((visit_date >=
> '$sdatestring') and (visit_date < '$edatestring')) and (site_id=$site_id))
> 
> This gives me the right figure, but when I try to pull out the date that
> this occured on with,

SELECT * FROM visit WHERE (((visit_date >=
  '$sdatestring') and (visit_date < '$edatestring')) and 
(site_id=$site_id)) ORDER BY visits DESC LIMIT 1;

Regards, Jigal.
Thread
MAX select problemLee Denny29 Jul
  • Re: MAX select problemJigal van Hemert29 Jul
  • Re: MAX select problemPhilippe Poelvoorde29 Jul