Ben Miller wrote:
I am trying to get the total sales revenue for each day of the month, and
having no luck at all.
<snipped/>
In case it helps, sample table data might look like this:
OrderNo OrderDate Revenue
1111 1 79.95
1112 1 39.95
1113 3 89.95
I would guess that you have a char type for your Revenue Column which
would lead to this situation. If you are unsure about which data type to
use you will have to ask in a mysql mailing list.
you might also want to echo out your query and run it directly in the
mysql client to see what happens. Liberal user of
error_log(mysql_error()) in your code would probably help too.
--
Raditha Dissanayake.
------------------------------------------------------------------
http://www.radinks.com/print/card-designer/ | Card Designer Applet
http://www.radinks.com/upload/ | Drag and Drop Upload
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
