query("SELECT * FROM articleStorage ORDER BY articleID DESC LIMIT 20;"); header('Content-Type: text/xml; charset=UTF-8'); echo "\n", "\n", "\t\n", "\t\t\n", "\t\t\n", "\t\thttp://sombraencounter.com/\n", "\t\tes\n", "\t\tsombraencounter.com\n", "\t\t\tSun, 03 Jan 2010 10:30:14 +0000\n", "\t\t\tsombra2eternity\n"; while($row = $results->fetchArray(SQLITE3_ASSOC)){ $d = explode("-",$row['articleDate']); $articleLink = $baseLink.$d[0]."/".$d[1]."/".$d[2]."/".$row['articleName']."/"; echo "\t\t\n", "\t\t\t\n", "\t\t\thttp://sombraencounter.com/".$articleLink."\n", "\t\t\thttp://sombraencounter.com\n", "\t\t\t".date("D, d M Y",strtotime($row['articleDate']))." ".$row['articleTime']." +0000\n", "\t\t\t\n", "\t\t\t".$articleLink."\n", "\t\t\t".html_entity_decode($row['articleSnippet'],ENT_QUOTES,"UTF-8")."\n", "\t\t\n"; } echo "\t\n", ""; ?>