$sql = "SELECT ca_name, COUNT(*) as cnt FROM $write_table WHERE wr_comment = 0 AND wr_datetime >= '$thismonthday' GROUP BY ca_name ORDER BY cnt DESC LIMIT $rank_limit";

$res = sql_query($sql);
$data = array();
while ($row = sql_fetch_array($res))
{
	$res2 = sql_query("SELECT EXTRACT(MONTH FROM wr_datetime) as mo, COUNT(*) as cnt 
									   FROM $write_table 
									   WHERE wr_comment = 0 AND ca_name = '{$row[ca_name]}' AND wr_datetime >= '$thisyear' 
									   GROUP BY EXTRACT(YEAR_MONTH FROM wr_datetime)");

	$year_data = array();	
	while($row2 = sql_fetch_array($res2)) {
		$year_data[$row2['mo']] = $row2['cnt'];
	}									
	for($i=1; $i<=12; $i++) {
		if(!isset($year_data[$i])) $year_data[$i] = 0;
	}   
	ksort($year_data);
	array_push($data, array('name'=>$row['ca_name'], 'count'=>$row['cnt'], 'yeardata'=>$year_data));
}