[RESOLVED] Date problem

[Mark_Nordstrom]

I wanna know is it possible to quey 2 different dates in one table ? Example I wanna show 3 columns.

Name, 30day, 60day.

problem is i gotta use COUNT(name)/COUNT(event) for 30day and 60day the issue is i need both to show in same quey. I can use WHERE date > etc to get 30 or 60 but i cant get both in the same quey.

[nemonoman]

in case you want to know how to do this, the form is:

SELECT sum(if(date>CURRENT_DATE()-INTERVAL 30 DAY, 1,0))
FROM table

returns number of records where date is more than 30 days ago

Just keep adding this form for addtional intervals

SELECT sum(if(date>CURRENT_DATE()-INTERVAL 30 DAY, 1,0)).
sum(if(date>CURRENT_DATE()-INTERVAL 30 DAY&&date<CURRENT_DATE()-INTERVAL 60 DAY, 1,0)),
sum(if(date>CURRENT_DATE()-INTERVAL 60 DAY&&date<CURRENT_DATE()-INTERVAL 90 DAY, 1,0))

FROM table

etc