"; ?> http://www.aneki.com Latest updates from Aneki.com World Rankings '2013-07-10' ORDER BY date DESC"; //$query1="SELECT * FROM updates ORDER BY date DESC"; $results1=mysql_query($query1); while (($line = mysql_fetch_array($results1)) ) { $id=$line[0]; $title=htmlspecialchars($line[1], ENT_COMPAT,'ISO-8859-1', true); //$body=$line[2]; $body=htmlspecialchars(stripslashes($line[2]), ENT_COMPAT,'ISO-8859-1', true); $url=htmlspecialchars($line[3]); $image_url=$line[4]; $source=$line[5]; $category=$line[6]; $date_time=$line[7]; $date = new DateTime($line[7]); $formatted_date_time2=$date->format('Y-m-d H:i:s'); $formatted_date_time=date('D, d M Y H:i:s T',strtotime($date_time)); $imageCode=""; if($image_url!=null) {$imageCode="";} if(strpos($url,"http")===false) {$url="http://www.aneki.com/".$url;} //if(3>2) if(strpos($url,"aneki.com")!=false) { print""; print""; print""; print"$url"; print""; print""; print"$body"; print""; print"$id"; print"$formatted_date_time"; print""; } } mysql_close($link); ?>