i have a log file in which i record every visit of my site, although some
times a visitant came by the morning and by the night or something alike, so
i am trying to create a select command which count the ip every since he
came back a hour afther of his last visit, the command is just like this:
SELECT id, ip, date_format(data,"%d/%m/%Y %r")
FROM log
WHERE date_format(data,"%d/%m/%Y")="05/02/2002"
AND ip != "200.19.73.64"
GROUP BY ip
HAVING count(date_format(data,"%d/%m/%Y %H"))>=2
but its not working well, can anyone help me build a correct select command?
thanks advanced.
sql,query
....................................idéias.ual..............................
........
Idéias Pontual Desenvolvimento de Software Ltda.
Ricardo Striquer Soares
CEO e-business
Fone: +55 (41) 322-9373 Cel: +55 (41) 9908-3862
Fax: +55 (41) 223-7865
Mr. Lucro : www.mrlucro.com.br
............................................................................
............
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
