Query Last 12 Mos

//show rolling stats for last 12 mos, out args by ref 
// month names csv, smoked events csv, water events csv 
function eventsfor_last12Months(&$d,&$s,&$w){

        $mname = array(0, 'Jan','Feb','Mar','Apr','May','June','July','Aug','Sept','Oct','Nov','Dec', 14);
	$y=0; 
	$year_index=0;
	$month = date("m"); //start month number
	
        for($i=12; $i>0; $i--){
		$mi = $month - $y; //month index
		
		if($mi <= 0){
			 $mi += 12; 
			 $year_index = 1; //we have crossed into previous year now...
		}
		
		//echo $mi. ",";
		$d[$i-1] = $mname[$mi];
		
		$r = mysql_query("SELECT count(autoid) as c FROM humidor WHERE MONTH(tstamp) = $mi AND 
                                 YEAR(tstamp) = (YEAR(NOW()) - $year_index) and smoked=1");

		$rr = mysql_fetch_assoc($r);
		$s[$i-1] = $rr['c'];
		
		$r = mysql_query("SELECT count(autoid) as c FROM humidor WHERE MONTH(tstamp) = $mi AND 
                                 YEAR(tstamp) = (YEAR(NOW()) - $year_index) and watered=1");

		$rr = mysql_fetch_assoc($r);
		$w[$i-1] = $rr['c'];
		
		$y+=1;
	}
	//echo var_dump($d);
	$d = arytocsv( $d, 1 );
	$s = arytocsv( $s );
	$w = arytocsv( $w );
}