pradosoft / prado

		return $comments;

	}

	public function queryCommentsByPostID($id)

	{

		$sql="SELECT * FROM tblComments WHERE post_id=? ORDER BY create_time DESC";

		$command=$this->_db->createCommand($sql);

		$command->bindValue(1, $id);

		$rows=$command->query();

		$comments=array();

		foreach($rows as $row)

			$comments[]=$this->populateCommentRecord($row);

		return $comments;

	}

	public function insertComment($comment)

	{

		return $cats;

	}

	public function queryCategoriesByPostID($postID)

	{

		$sql="SELECT a.id AS id,

				a.name AS name,

				a.description AS description,

				a.post_count AS post_count

				FROM tblCategories a, tblPost2Category b

				WHERE a.id=b.category_id AND b.post_id=? ORDER BY a.name";

		$command=$this->_db->createCommand($sql);

		$command->bindValue(1, $postID);

		$rows=$command->query();

		$cats=array();

		foreach($rows as $row)

			$cats[]=$this->populateCategoryRecord($row);

		return $cats;

	}

	public function queryCategoryByID($id)

	{