add value in same date + between two dates for mysql jquery

SELECT SUM(`total`) AS `total` from `order` WHERE date >= '".$from."' AND date <= '".$to."' GROUP BY DATE(`date`)