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