$labels[$i] = date("M", mktime(0, 0, 0, $i)); $colors[$i] = array('r' => 0xcc, 'g' => 0x33, 'b' => 0x33); } // retrieve total hits $query = sprintf(' SELECT MONTH(ACCESS_TIME) AS ATIME, COUNT(IP_ADDRESS) AS TOTAL FROM %sSITE_ACCESS WHERE DATE(ACCESS_TIME) BETWEEN "%d-01-01" AND "%d-12-31" GROUP BY ATIME ORDER BY ATIME ASC', DB_TBL_PREFIX, $year, $year); $result = mysql_query($query, $GLOBALS['DB']); while ($row = mysql_fetch_assoc($result)) { $data[$row['ATIME']] = $row['TOTAL']; } mysql_free_result($result); } else { die; } } // present bar chart $chart = new BarChart(500, 200); $chart->graphData($data, $colors, $labels); $chart->flushImage();