Code:
//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";
_________________
We will rule the world!
Oops i dropped my cookie!
http://pegpro.efhost.com I Wish I Game
http://www.sls.r8.org Quick Fun/Games
http://www.pegproandlhsart.com My Buisness

