Ben Miller wrote:

I am trying to get the total sales revenue for each day of the month, and
having no luck at all.


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.
------------------------------------------------------------------ | Card Designer Applet              | Drag and Drop Upload

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to