On Mon, 2002-11-18 at 17:01, OYNot wrote:
[snip]
> //The following was supposed to create a count, by day, of the unique ip
> addresses.
You can use the date_format() to convert timestamps and dates into
whatever format you want.
I think you only need a single query like:
select ip, date_form
Hi!
I've had a good look through the documentation and here is where I am:
I'm logging users coming in to a web site, by ip address column called ip
and by dateIn (a
timestamp of 14 bytes). I'd like to list (one row per day) the COUNTs of
unique (DISTINCT) ip addresses. I'd also like to have t
