mysql date select statement

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux