if else in mysql query

[bugcoder]

hi everybody

 

i have this query

 

SELECT count(*) FROM `journal_entries` WHERE `created` BETWEEN '2011-07-01 00:00:00' AND '2011-08-03 00:00:00' AND `user_id` = 8;

 

one user can add more than one journal entry per day. I just want to consider one entry per day. if there is one entry, it should be counted in count(*) else not. can i do it just with mysql?

[Muddy_Funster]

I'm not sure I follow.  Do you want one count per day, one count per user, or one count per user per day? None of which really fit with what you are currently using in your where clause.

[bugcoder]

e.g if date range is for 7 days

 

and user added 15 journal entries but out of 7 days, one day he didn't add any entry. then result should be 6.

 

i.e we should not bother how many entries he did on one day. if he did even ten entries on one day it should be counted as 1 count.

 

I hope im able to clear my point... :-\

[kickstart]

Hi

 

Something like this maybe

 

SELECT COUNT(DISTINCT DATE(created)) FROM `journal_entries`

WHERE `created` BETWEEN '2011-07-01 00:00:00' AND '2011-08-03 00:00:00' AND `user_id` = 8;

 

All the best

 

Keith

[bugcoder]

 

SELECT COUNT(DISTINCT DATE(created)) FROM `journal_entries`

WHERE `created` BETWEEN '2011-07-01 00:00:00' AND '2011-08-03 00:00:00' AND `user_id` = 8;

 

 

exact result....Thanks a lot......