<?PHP

class Blogg
{
	var $limit = 10;
	var $db;
	
	function Blogg()
	{
		$db = new leDB();
	
	}
	//GET FUNCTIONS
	function getBlogg($blogg_id = NULL,$category = NULL)
	{
		
		#ONLY GET ONE BLOG. FOR EXAMPLE TO USE WITH blogg.php?id=2314		
		if($blogg_id)
		{
			$data = $db->select("*","blogg","blogg_id =".$blogg_id);
			
			
		}	

		else
		{
			if($category)
				$data = $db->select("*","blogg","cat_id = ".$category,"date desc",$this->limit);
			else
				$data = $db->select("*","blogg",NULL,"date desc",$this->limit);
			

		}	
		
		return $data;
	}

	function numComments($blogg_id)
	{
	
		$db->select("comment_id","comments","blogg_id =".$blogg_id);
		
		return $db->numRows();
	
	}

	function getComments($blogg_id)
	{
		return $db->select("*","comments","blogg_id =".$blogg_id);
	
	}
	
	
	function latestComments($limit)
	{
		$db = new leDB();
		return $db->select("*","comments",NULL,NULL,$limit);
	}

	//PUT/SAVE FUNCTIONS
	
	function writeBlogg($cat_id,$blogg_title,$blogg_text,$blogg_tags,$date, $user_id = NULL)
	{
		$blogg_title = mysql_real_escape_string($blogg_title);
		$blogg_text = mysql_real_escape_string($blogg_text);
		$blogg_tags = mysql_real_escape_string($blogg_tags);

		$data = "NULL,'{$cat_id}','{$blogg_title}','{$blogg_text}','{$blogg_tags}',now(),'{$user_id}'";		
		
		$db->insert("blogg",$data);
	}


}





?>