MySQL组相同的标题（行）和金钱（行）相加，但保留单独的时间戳进行排序

Question

I have been all over the internet to find answer for this, but I can't find any. (I might be asking incorrectly?) I have a table which looks like this: I have been using the query:

SELECT title, date, SUM(money) 
FROM payments 
WHERE username = '$username_n' and type=0 
GROUP BY title

It does the trick, and it groups the identical titles and sum up their values

But as you can see, it only gives me ONE date, and I would like to be able to make a slider, where I can sort the date from the date, but I can't do that if it creates only one date for each grouped title.

How can I create multiple dates, but still get rid of the duplicated titles?

Answer 1

Try this:

SELECT title, date, SUM(money) FROM payments 
WHERE username = '$username_n' and type=0 GROUP BY title, date(`date`);