query($sql); while($row = $result->fetch_assoc()){ $news[] = $row; } return $news; } function getNewsById($id){ $query="SELECT * FROM news WHERE deleted !=1 AND active = 1 AND id = '".$id."'"; $result = $GLOBALS['mysqlconnection']->query($query); $row = $result->fetch_assoc(); return $row; } function getRealDate($date){ $news_date_array = explode("-",$date); $d = $news_date_array[2]; $m = $news_date_array[1]; $y = $news_date_array[0]; return $d.".".$m.".".$y; } function getMedia($news_id){ $query = "SELECT * FROM news_media WHERE news_id ='".$news_id."' ORDER BY reihenfolge asc"; $result = $GLOBALS['mysqlconnection']->query($query); while($row = $result->fetch_assoc()){ $bilder[] = $row; } return $bilder; } ?>