A real tricky one making added table structure

brooky

Hi,

I am trying to get a list of hits by date:

[FONT=courier new]HITS METHOD DATE
20 web 20040312
5 email 20040312
3 web 20040311

Into:
HITS DATE
25 20040312
3 20040311[/FONT]

Is there an SQL statement which can do this? I've been going insane trying to filter it with PHP!!

bastien

$sql="select hits, dateField from table where method = 'web' 
order by dateField desc";

this assumes that hits is a total type field and does not need to be summed in the query

brooky

Hi and thanks for your help. I do require that field to be summed up.

Do you know how. Currently I'm working with arrays of a version without where method=xxx??

Cheers,

bastien

$sql="select sum(hits), dateField from table where method = 'web' 
group by dateField
order by dateField desc";

Why would you get more data than what you need...it adds a layer of complexity that doesn't need to be there...and i bet it make soing thru your arrays hell...

rule of thumb...where you can, let the db do all the work...its much faster than code in sorting, adding, excluding and manipulating resultsets

brooky

Ahhhh thats great!!

Really helpful indeed. I have to get my head around this grouping method. 🙂