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]."'"