MySQL Select Distinct

[mousematt]

Hi, need some sql help

I have a table that i use to log IP Addr's and dates of people looking at my site, I want to count the entries for each dates so I can make a graph, any ideas?

table is simple looks like;

t_id t_ip t_date

 

[hoinz]

Hi,

I would use group by rather than distinct.
Something like this:
select t_date, count(*) from my_table group by t_date;
Or perhaps this:
select t_ip, t_date, count(*) from my_table group by t_ip, t_date;

hope this helps