How to check number of Users that come online in a month via MySQL?

[marcus_green]

CREATE TABLE t1 (year YEAR(4), month INT(2) UNSIGNED ZEROFILL,
day INT(2) UNSIGNED ZEROFILL);
INSERT INTO t1 VALUES(2000,1,1),(2000,1,20),(2000,1,30),(2000,2,2 ),
(2000,2,23),(2000,2,23);

In order to differentiate how many different days in each month of visits take place, you can use the following query -

SELECT year,month,BIT_COUNT(BIT_OR(1<<day)) AS days FROM t1
GROUP BY year,month;

The query will automatically remove duplicate visits.

[Christina]

hmmm..i suppose this can be used as an alternative to Awstats through cPanel, but i am not sure if it can give even detailed information on visitors.

[carl]

Is this is the only way for checking the visitors who came online via My SQl in a day.

[marcus_green]

MySQL functions are well-known, and i suppose christina might be right here in case of alternatives. :D