Re: select date range?

On Tue, 17 Jun 2003, ko wrote:

> Hi,
> 
> When I use sql statement to select the date range from $_POST value,It doesn't work.
> 
> -------------------------------------------
> "select * from mydatabase where mydate between '$_POST[start_date]' and '$_POST[end_date]' "
> 
> There is no error,but the result is not I want.
> 
> ps:
> (1)mydate attribute is timestamp
> (2)$_POST[start_date] is something like '2003/05/12'

You may be having problems with how PHP interprets (or more correctly, 
doesn't) arrays inside of strings.  the problem is that inside of a string 
the autointerpretation of a string won't work for arrays, only simple 
scalars.

Change your string to this:

"select * from mydatabase where mydate between '".$_POST[start_date]."' and '".$_POST[end_date]."'"