Re: can't get it to work
| From: | Miguel Cruz | Date: | Wed, 03 Apr 2002 18:45:49 +0000 |
| Subject: | Re: can't get it to work | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-91359@lists.php.net to get a copy of this message | ||
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