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