Re: mysql date select statement

[Shahmat Dahlan <shahmatd@sains.com.my>]

hav u tried using dashes to denote which portion is the year, month, or 
day ?
e.g. instead of 20030101, you'd probably want to use 2003-01-01.

Wendell Frohwein wrote:

> Hello all, I have this page where I search and add up commissions in a
> mysql database. I want to select commissions between a certain date
> range.
> This is what im currently using but it does not seem to work.
>
>
> $from="20030101";
> $to="20031230";
>
> $search=mysql_query("SELECT SUM(amount) FROM commissions WHERE date
> BETWEEN '$from' AND '$to'");
>
>
>
> Thanks in advance for any help
>
>
>
> wendell
>
>  



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php