Re: [PHP-DB] mysql date select statement

[Shahmat Dahlan]

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