use the DISTINCT(IP) (the DISTINCT keyword)
bastien
From: "septic" <nrasidakis@xxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: 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 database.
table = tracker
FIELDS
ip
day
month
year
session_id
browser of visitor
page that was visited
What I would like to do next, is simple to create an output of that
database with the last time that every different IP has visited my website.
the best output I have at the moment is:
$query = "SELECT ip,day,month,year FROM tracker WHERE page = 'index' ORDER
BY `tracker`.`year` DESC , `tracker`.`month` DESC , `tracker`.`day` DESC
LIMIT 0,20 ";
The problem is that I want to Keep for each different IP the fisrt entry
that is found on this output I get.
therefore I would say that the output would represent the last visit of
each
different user on my website.
do you know of a php or sql trick to avoid entries that containt the same
IP
entries ?
Thanks in advance for the help.
Nikos.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
_________________________________________________________________
Have Some Fun Out Of The Sun This March Break
http://local.live.com/?mkt=en-ca/?v=2&cid=A6D6BDB4586E357F!142
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
