I am running the following query:

Code:
SELECT from_unixtime(swp.dateline, '%Y %M %D') as datelineDates, s.fullname, count(*) as totalTickets FROM swticketposts swp, swstaff s
WHERE s.staffid=swp.staffid
Group By swp.dateline,s.fullname
And getting results similar to

'2008 December 1st', 'Brandon', '1'
'2008 December 1st', 'Brandon', '1'
'2008 December 1st', 'Joe', '1'
'2008 December 1st', 'Joe', '1'
'2008 December 1st', 'Joe', '1'
'2008 December 1st', 'Joe', '1'
'2008 December 1st', 'Joe', '1'
'2008 December 1st', 'Brandon', '1'
'2008 December 1st', 'Joe', '1'
'2008 December 1st', 'Brandon', '1'
'2008 December 1st', 'Cherie', '1'
'2008 December 1st', 'Brandon', '1'

What I would like is to see something like:

'2008 December 1st', 'Joe', '6'
'2008 December 1st', 'Brandon', '5'
'2008 December 1st', 'Cherie', '1'

Where am I going wrong with this query?