=CURDATE() AND element_6_1='1' ORDER BY element_1 ASC LIMIT 4"; $resultID = mysql_query($query, $linkID) or die("Data not found."); $num_rows = mysql_num_rows($resultID); function format_phone($phone) { $phone = preg_replace("/[^0-9]/", "", $phone); if(strlen($phone) == 7) return preg_replace("/([0-9]{3})([0-9]{4})/", "$1-$2", $phone); elseif(strlen($phone) == 10) return preg_replace("/([0-9]{3})([0-9]{3})([0-9]{4})/", "($1) $2-$3", $phone); else return $phone; } $xml_output .= "\n"; $xml_output .= "\n"; $xml_output .= " \n"; $xml_output .= "\t\n"; $xml_output .= "\thttp://www.fatandjuicy.com/calendar\n"; $xml_output .= "\t ... happening this month at Fat and Juicy!\n"; if ($num_rows > 0) { for($x = 0 ; $x < mysql_num_rows($resultID); $x++){ $row = mysql_fetch_assoc($resultID); // // Escaping illegal characters $row['element2'] = str_replace( array("’", "+", "®", "–", "—", "“", "”"), array("'", "and", "", "-", "-", "", ""), $row['element_2']); $row_title = str_replace('+','',$row['element_4']); // $row['head'] = str_replace("<", "<", $row['element_10']); // $row['head'] = str_replace(">", ">", $row['element_10']); // $row['head'] = str_replace("\"", """, $row['element_10']); $xml_output .= "\t\n"; $xml_output .= "\t\t". date('m.d.y', strtotime($row['element_1'])) ."\n"; $xml_output .= "\t\t\n"; $xml_output .= "\t\thttp://www.fatandjuicy.com/app/calendar/events-detail.php?event_id=". $row['id'] ."\n"; $xml_output .= "\t\t". date('m.d.y', strtotime($row['element_1'])) ."\n"; $xml_output .= "\t\t". date('l, F jS Y', strtotime($row['element_1'])) ." - \n"; $xml_output .= "\t\n"; } } else { $xml_output .= "http://www.fatandjuicy.com/retailWe're cooking up some plans.... Oh yeah!We're cooking up some plans.... Oh yeah!"; } $xml_output .= " \n"; $xml_output .= "\n"; echo $xml_output; mysql_close($linkID); ?>