Re: [PHP-DB] Count unique visits in PHP/MySQL

2004-06-08 Thread Ignatius Reilly
1 ) ) AS unik_visits FROM T LEFT JOIN U ONU.ip = T.ip AND U.rank = T.rank + 1 GROUP BY ip HTH Ignatius _ - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 08, 2004 5:03 PM Subject: [PHP-D

[PHP-DB] Count unique visits in PHP/MySQL

2004-06-08 Thread veditio
I am making a PHP/MySQL traffic report page from a table that records some user activity using PHP referrer information. I have a table with three rows: IP, page_name, and timestamp. The IP row records the user's IP address, page_name records the name of the page that the user loaded, and the t