public function create_archive()
	{
		// Loop through the database grabbing all the dates::
		// $sql = "SELECT DISTINCT blog_date FROM subarc_blog ORDER BY blog_date";
		$sql = "SELECT DISTINCT MONTHNAME(blog_date) as blog_month, YEAR(blog_date) as blog_year FROM subarc_blog ORDER BY blog_date";
		
		$stmt = $this->conn->prepare($sql);
		$stmt->execute();
		$stmt->bind_result($month,$year);
		
		$rows = array();
		
		while($row = $stmt->fetch())
		{
			$item = array(
				'blog_month' => $month,
				'blog_year' => $year
			);
			$rows[] = $item;
		}
		$stmt->close();
		return $rows;
	}

public function create_archive()
	{
		// Loop through the database grabbing all the dates::
		$sql = "SELECT blog_date FROM subarc_blog";
		
		$stmt = $this->conn->prepare($sql);
		$stmt->execute();
		$stmt->bind_result($date);
		
		$rows = array();
		
		while($row = $stmt->fetch())
		{
			$date = explode("-",$date);
			$month = date("F",mktime(0,0,0,$date['1']));
			$year = $date[0];

			$item = array(
				'blog_month' => $month,
				'blog_year' => $year
			);
			$rows[] = $item;
		}
		$stmt->close();
		return $rows;
	}

This has been updated, fully working now

Create Archive Function

PHP