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.
$search=mysql_query("SELECT SUM(amount) FROM commissions WHERE date BETWEEN '$from' AND '$to'");
Thanks in advance for any help
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php