hi,

I have a MySQL query that pulls off a report from database.

SELECT DATE_FORMAT(s.date,'%d-%m-%Y') as date, s.customer, s.biller, si.product_name, FLOOR(si.quantity) as quantity, FLOOR(si.unit_price) as unit_price
FROM sale_items si, sales s
WHERE s.warehouse_id = si.warehouse_id 
AND s.id = si.sale_id
AND ".$ssucursal."
AND si.product_code = '".$sku."'
AND s.date >= '".$iniDate."' AND s.date <= '".$endDate."'
ORDER BY s.date DESC

I get a date-wise report from this for example if a given product is sold ten times in a single day it will show ten records and quantity of each sale.
I want to get a daily total of the daily sales as well, so I know what is the total quantity sold in ten sales in that given day.

I am caught off the guard, please guide :)

thank you