[RESOLVED] Getting MySQL SUM values for time period, ie sum of totals from date1 to date2.

[bmx269]

I feel like a user, just asking for help all the time, but thats life. Sorry.

I am trying to make sales reports from a MySQL database. I have successfully made a report for 1 day, ie 2005-08-08, what I would like to do is generate a report from lets say 2005-07-08 to 2005-08-08, I am not sure how I could write this, if it can be done. Any help or feedback would be great. The date is passed fron the URL, so I would assume that it would be $date1 = start date; $date2 = end date; Thanks

This is the code I use for one query to get totals for 1 date:

SELECT SUM(item_price*quantity) FROM invoice_items WHERE date = '$date1'  AND item_type = 'Parts' AND status = 'POSTED'"

-Trent

[devinemke]

SELECT SUM(item_price * quantity) FROM invoice_items WHERE date BETWEEN '$date1' AND '$date2' AND item_type = 'Parts' AND status = 'POSTED'

[bmx269]

PERFECT. Thank you VERY much.

-trenT