Code: Select all
//Sql Query
//Day Name
$sql = "SELECT count(*) as cnt, DAYNAME(date) as dnr, TO_DAYS(date) as tdr FROM $dbsql WHERE date >= DATE_SUB( CURRENT_DATE, INTERVAL 6 day ) GROUP BY dnr,tdr ORDER BY tdr";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$comma = ",";
$xdata .= '"'.$row[dnr].'"'.$comma;
}
//Data
$sql = "SELECT count(*) as cnt, DAYNAME(date) as dnr, TO_DAYS(date) as tdr FROM $dbsql
WHERE date >= DATE_SUB( CURRENT_DATE, INTERVAL 6 day ) GROUP BY dnr,tdr ORDER BY tdr";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$comma = ",";
$ydata .= $row[cnt].$comma;
}
//Trim Extra Commas
$ydata = substr($ydata, 0, strlen($ydata)-1);
$xdata = substr($xdata, 0, strlen($xdata)-1);
$y = array($ydata);
$x = array($xdata);
$title = "Unique Hits/Day";
$labelx = "Day";
$labely = "Unique Hits";