If you are trying to gather meaningful statistics from your weblog, you might wish to consider the open source program Analog (http://www.analog.cx). It works on windows, *nix, and took me less than 5 minutes to set up. There is also fine documentation about weblog processing in general at http://www.analog.cx/docs/webworks.html
Regards, Gary "SuperID" Huntress ======================================================= FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org ----- Original Message ----- From: "herve.bayou" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 23, 2001 11:36 AM Subject: I want to drop "double click" from apache's log store in mysql table Hello and a big thank's to all mysql team for your wonderfull product. I use a mysql table to store my apache's logs. The table is like CREATE TABLE IF NOT EXISTS log ( ip char(12) not null, date datetime not null, ... PRIMARY KEY ( date, ip ) ); Some times, people double click on a link so I get 2 records with several seconds between them. To make a "real count" I want to keep only one of them. How can I do with one (or more) sql request ??? Thank's for your help. "Ce message vous est envoyé par laposte.net - web : www.laposte.net/ minitel : 3615 LAPOSTENET (0,84 F TTC la minute)/ téléphone : 08 92 68 13 50 (2,21 F TTC la minute)" --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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