pradosoft / prado

		$command->execute();

	}

	public function insertPostCategory($postID,$categoryID)

	{

		$sql="INSERT INTO tblPost2Category (post_id, category_id) VALUES (?, ?)";

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

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

		$command->bindValue(2, $categoryID);

		$command->execute();

		$sql="UPDATE tblCategories SET post_count=post_count+1 WHERE id=?";

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

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

		$command->execute();

	}

	public function deletePostCategory($postID,$categoryID)

	{

	}

	public function deletePostCategory($postID,$categoryID)

	{

		$sql="DELETE FROM tblPost2Category WHERE post_id=? AND category_id=?";

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

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

		$command->bindValue(2, $categoryID);

		$result=$command->query();

		if($result->getRowCount()>0)

		{

			$sql="UPDATE tblCategories SET post_count=post_count-1 WHERE id=?";

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

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

			$command->execute();

		}

	}

	public function queryEarliestPostTime()

	{