Re: can't get it to work

That did the trick. Thank you "Miguel Cruz" <mnc@stoic.net> wrote in message news:Pine.LNX.4.44.0204031245080.1232-100000@stoic.net... > 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. > > > > $query = SELECT * FROM table where date >= '$month_1/$day_1/$year_1' AND > > date <= '$month_2/$day_2/$year_2'; > > By the way, here's your parse error. You need to quote strings. > > $query = "SELECT ... "; > > miguel > >