[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

  `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
drawing blanks.


Phil Dowson

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to