Re: MAX select problem

2005-07-29 Thread Philippe Poelvoorde
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

Re: MAX select problem

2005-07-29 Thread Jigal van Hemert
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

MAX select problem

2005-07-29 Thread Lee Denny
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