Figuring Out the Best Day in stats program
| From: | JJ Harrison | Date: | Sat, 06 Jul 2002 15:00:25 +0000 |
| Subject: | Figuring Out the Best Day in stats program | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-105862@lists.php.net to get a copy of this message | ||
I have been going fine in a Web Stats program until now.
How can I figure out which day has had the most records(ie visitors)
inserted?
There is a time column which has unix timestamp of when the record was
inserted.
The best I can think of currently is:
To use a while loop to repeatedly query the DB.
then use an if statement to replace two variables(UNIX timestamp and number
of visitors) if the value returned is higher.
--
JJ Harrison
webmaster@tececo.com
www.tececo.com