Re: can't get it to work

On Wed, 3 Apr 2002, Alex wrote: > I'm trying to write code that will return all records found between certain > dates(e.g. 2001-01-30 through 2002-01-30). I created a html form with pull > down menus for both dates but when I try to run it I get a parse error and > can't figure out what's wrong. It should tell you on which line the parse error occurred. That's generally a helpful piece of information. If the parse error is at the end of the file, you probably have an unclosed quote or brace. > $query = SELECT * FROM table where date >= '$month_1/$day_1/$year_1' AND > date <= '$month_2/$day_2/$year_2'; Does MySQL understand dates in that weird order? I would imagine they have to be in ascending or descending order of unit size (year-month-day or day-month-year). miguel