This is what i got
[code=php] $sql = “SELECT count(*) as cnt, DAYNAME(recieved) as dnr,
TO_DAYS(recieved) as tdr
FROM $dbsql
WHERE recieved >= DATE_SUB( CURRENT_DATE, INTERVAL 6 day )
GROUP BY dnr,tdr
ORDER BY tdr”;
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$l->AddValue(“$row[dnr]”, array($row[cnt]));
}
My table structure is like so:
id browser ip recieved refer
1 Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv… 87.113.14.220 2006-11-28 None
2 Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv… 87.113.14.192 2006-11-23 None
3 Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv… 87.112.26.158 2006-11-24 None
4 Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv… 87.113.14.220 2006-11-25 None
5 Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1;… 87.113.14.220 2006-11-26 None
6 Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;… 87.113.14.220 2006-11-29 None
7 Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv… 87.113.14.220 2006-11-27 None
8 Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv… 87.113.14.220 2006-11-22 None
9 Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv… 87.113.14.220 2006-11-29 [url]http://shogans.com/stats/
10 Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv… 87.113.14.220 2006-11-29 None
11 Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv… 87.113.14.220 2006-11-29 [url]http://www.shogans.com/index.php?do=newestmembers
12 Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv… 87.113.14.220 2006-11-29 [url]http://www.shogans.com/index.php?do=gotown:1
13 Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv… 87.113.14.220 2006-11-29 [url]http://www.shogans.com/index.php
14 Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv… 87.113.14.220 2006-11-29 [url]http://www.shogans.com/index.php?do=fight
15 Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv… 87.113.14.220 2006-11-29 [url]http://www.shogans.com/index.php?do=victory
I am trying to produce something that counts the unique hits for the past seven days and outputs it using this template:
$l->AddValue(“*The Day*Unique hits for that day
eg:
$l->AddValue(“Friday”, array(126));
As then this is taken by a graph generator and drawn.
Any help would be appreciated