Re: mysql date select statement
| From: | John W. Holmes | Date: | Mon, 18 Aug 2003 04:09:30 +0000 |
| Subject: | Re: mysql date select statement | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-29930@lists.php.net to get a copy of this message | ||
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'");Always use mysql_error() with your queries to see the error. You do not have a GROUP BY clause in your query, so it's failing. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ PHP|Architect: A magazine for PHP Professionals – www.phparch.com