Count results of select

[guitardave78]

Hey all, i have the following query

SELECT date_format(log_date,'%d/%m/%Y') AS dt, count( log_id ) AS count,log_ip
FROM tbl_logs
group by dt,log_ip

what i want is to just produce a count for dt

so the table would look like

dt | dtcount
----------------------
16/04/2007 | 20
17/04/2007 | 25
18/04/2007 | 19

}...the bane of my life!

http://www.yetanotherreviewsite.co.uk

http://www.fuzzyd.co.uk

 

[r937]

SELECT date_format(log_date,'%d/%m/%Y') AS dt
, count(*) AS dtcount
FROM tbl_logs
GROUP BY dt

r937.com | rudy.ca