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 ............................................................................ ............ _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --------------------------------------------------------------------- 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