Re: Grouping timestamps by day...

VERY VERY rough guess, but something like SELECT COUNT(*) AS vistors, TO_DAYS(timestamp) AS date FROM table GROUP BY TO_DAYS(timestamp) I think something like that might work, the only problem is that will show hits, NOT unique visits, if you want to show unique visits, then you will have to do some addiation SQL, something like: SELECT COUNT(DISTINCT ipaddress) AS vistors, TO_DAYS(timestamp) AS date FROM table GROUP BY TO_DAYS(timestamp) Unsure if any of this will work, since I just looked all the commands up in the MySQL manual :), but its worth a try Andrew ----- Original Message ----- From: "Jeff Lewis" <jeff@hyrum.net> To: <php-general@lists.php.net> Sent: Wednesday, August 07, 2002 7:38 PM Subject: [PHP] Grouping timestamps by day... I have a table of values that look like this: timestamp | ipaddress | referer | useragent I want to set up a link so that when i click on it, it will break it down like so: August 7, 2002 - X visitors August 6, 2002 - X visitors August 5, 2002 - X visitors etc. How can I do this with the values stored as Unix timestamps? Any help would be greatly appreciated. Jeff