- Original Message -
From: "septic" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, March 14, 2007 4:29 AM
Subject: [PHP-DB] do not display dublicated entries
> Hello all,
>
> I have created a simple webtracer for my website and I save some info on
> mysql database.
>
> table = tracker
>
> FIE
use the DISTINCT(IP) (the DISTINCT keyword)
bastien
From: "septic" <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] do not display dublicated entries
Date: Tue, 13 Mar 2007 23:29:58 +0200
Hello all,
I have created a simple webtracer for my website and I save some info on
mysql
Hi
First, unless there is a compelling reason not to, I'd suggest you use
a single date field, instead of separate year, month, day columns. It
will be much more efficient on space and indexes.
Then, based on your own query, use:
SELECT DISTINCT ip, date FROM tracker WHERE page = 'index' ORDE
