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;
}
}