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