PHP/MySQL Question

[elecktricity]

Okay I have a database setup along the lines of:
|month|day|year|ip|

Is there a way I can find out how many unique hits I got that day? Besides grouping by ip? I would like to do this for more than one day per query so it would help much thanks in advance

 

[Dan]

SELECT DISTINCT ip FROM tablename WHERE day = $day

I don't know how you have day set up, but if it's a string or something just add quotes around it. I'm guessing you have today's date in the columns except for ip?

 

[elecktricity]

id like it to be grouped by day, month, year so it can be used better for a graph

 

[Dan]

SELECT DISTINCT ip FROM tablename WHERE day = $day && year = $year && month = $month

(I hope I'm right on how I'm using DISTINCT.. I've never used it before. :x)
Again, add quotes if you need to.

 

[LogiK]

You Could Setup A Page That Echos All That Information Everyday So That You Dont Have To Do Nothing.