View difference between Paste ID: yJPqnZN0 and CC2LKS6a

 <?php
 
-/* Array having the days as keys (YYYY-mm-dd) and the view count as values */
+/* Array having the MONTHS as keys (numeric month, from 1 to 12) and the view count as values */
-$days = array();
+$months = array();
 
 /* Initialize the days keys to 0, for both ads and phone */
-for ($i = 0; $i < 7; $i++)
+for ($i = 0; $i < 12; $i++)
 {
-	$dayUts = mktime(0, 0, 0, date('n'), date('j') - $i, date('Y'));
+	$monthUts = mktime(0, 0, 0, date('n') - $i, 1, date('Y'));
-	$day = date('Y-m-d', $dayUts);
+	$month = intval(date('m', $monthUts), 10);
-	$days[$day] = array('ads' => 0, 'phone' => 0);
+	$months[$month] = array('ads' => 0, 'phone' => 0);
 }
 
-/* Now read the view count from the DB */
+/* Now read the view count from the DB. I take the last 12 months. */
-$query = 'SELECT DATE_FORMAT(view_count_date, "%Y-%m-%d") AS time, count(*) AS view_count_ads, -1 AS view_count_phone FROM ads_view_count WHERE view_count_date >= (NOW() - INTERVAL 7 DAY) AND view_count_user_id = :id GROUP BY DATE_FORMAT(view_count_date, "%Y-%m-%d") UNION SELECT DATE_FORMAT(view_count_date, "%Y-%m-%d") AS time, -1 AS view_count_ads, count(*) AS view_count_phone FROM phone_view_count WHERE view_count_date >= (NOW() - INTERVAL 7 DAY) AND view_count_user_id = :id GROUP BY DATE_FORMAT(view_count_date, "%Y-%m-%d")';
+$query = 'SELECT DATE_FORMAT(view_count_date, "%m") AS time, count(*) AS view_count_ads, -1 AS view_count_phone FROM ads_view_count WHERE view_count_date >= (NOW() - INTERVAL 12 MONTH) AND view_count_user_id = :id GROUP BY DATE_FORMAT(view_count_date, "%m") UNION SELECT DATE_FORMAT(view_count_date, "%m") AS time, -1 AS view_count_ads, count(*) AS view_count_phone FROM phone_view_count WHERE view_count_date >= (NOW() - INTERVAL 12 MONTH) AND view_count_user_id = :id GROUP BY DATE_FORMAT(view_count_date, "%m")';
 
 /* Note: be sure to validate $_SESSION['id'] */
 $res = $pdo->prepare($query);
 $res->bindValue(':id', $_SESSION['id'], PDO::PARAM_INT);
 $res->execute();
 
-/* Now we update the $days array with the view count from the query */
+/* Now we update the $months array with the view count from the query */
 while ($row = $res->fetch(PDO::FETCH_ASSOC))
 {
-	if (array_key_exists($row['time'], $days))
+	$row_month = intval($row['time'], 10);
-    {
+	$ads_count = intval($row['view_count_ads'], 10);
-		$ads_count = intval($row['view_count_ads'], 10);
+	$phone_count = intval($row['view_count_phone'], 10);
-		$phone_count = intval($row['view_count_phone'], 10);
+
-
+	/* If view_count_ads is -1 it means this is a result from phone_vew_count */
-		/* If view_count_ads is -1 it means this is a result from phone_vew_count */
+	if (ads_count  == -1)
-		if (ads_count  == -1)
+	{
-		{
+		$months[$row_month]['phone'] = $phone_count;
-			$days[$row['time']]['phone'] = $phone_count;
+    }
-    	}
+	else /* Otherwise, it's a result from ads_vew_count */
-		else /* Otherwise, it's a result from ads_vew_count */
+	{
-		{
+		$months[$row_month]['ads'] = $ads_count;
-			$days[$row['time']]['ads'] = $ads_count;
+    }
-    	}
+