[I apologize if this comes through twice, the first time I sent it did not
appear to go through]
My problem is what I am trying to show the average number of visitors I am
getting on a daily basis over a given month. So for example, I would like
to be able to display the average number of visitors that came to my web
site on a Monday.
Included below is the table I am working with, also below there is the SQL
statement I am trying to work with to produce the results.
I have worked out how to show how many total visited my site on a Monday,
but I cannot work out how to (a) show how many Monday's (for example) there
were in a given month and therefore (b) how to turn the totals into an
CREATE TABLE `stat` (
`statid` int(11) NOT NULL auto_increment,
`stat01` varchar(100) default '',
`stat02` varchar(100) default '',
`stat03` datetime default '0000-00-00 00:00:00',
PRIMARY KEY (`statid`)
select count(weekday(stat03)) AS dayname from stat where and
date_format(rms03,'%m %Y') = '09 2003' and weekday(stat03) = '0'
I hope this is a simple question, I've googled for over an hour and I'm
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php