« Back to the main page

Language: PHP, Submitted: 8/16/11, Country: Canada - Raw | Download
function getdynamictitle($title)
{
	$pos_1			=	strpos($title,"{")+1;
	$pos_2			=	strpos($title,"}");
	$pos_length		=	$pos_2-$pos_1;
	$static_text	= 	substr($title,0,$pos_1-1);
	$values			=	explode(",",substr($title,$pos_1,$pos_length));
	
	switch ($values[0])
	{
		case "flyerdaterange":
		
			$query	=	"SELECT f.flyerdaterangestart,f. flyerdaterangeend FROM flyerdaterange f WHERE '";
			
						if 			($values[1]==1)	$query	.=	date("Y-m-d");
						else if		($values[1]==2)	$query	.=	date("Y-m-d", strtotime("-1 weeks"));
						else if		($values[1]==3)	$query	.=	date("Y-m-d", strtotime("+1 weeks"));
			
			$query	.=	"' BETWEEN f.flyerdaterangestart AND f.flyerdaterangeend";
			
			$result	=	mysql_fetch_assoc(mysql_query($query));
			
			return 		$static_text." ".date("M jS",strtotime($result['flyerdaterangestart']))." to ".date("M jS",strtotime($result['flyerdaterangeend']));
			
		break;
		
	}
}