شرکت مادر تخصصی فرودگاه‌های کشور http://www.airport.ir fa Airport.ir"; $entries = pg_query('SELECT Tbl.id, Tbl.titr, Tbl.lead, Tbl.news_date, Tbl.news_time FROM airport_site.news Tbl INNER JOIN airport_site.news_levels ON Tbl.id = news_levels.news_id WHERE Tbl.news_status = 3 AND (Tbl.news_type = 1 OR Tbl.news_type = 2) AND Tbl.language = 1 AND news_levels.portals_id = 1 AND Tbl.news_date <= \''. date('Y-m-d') .'\' ORDER BY Tbl.news_date DESC, Tbl.news_time DESC LIMIT 15'); while ($entry = pg_fetch_assoc($entries)) { $content = $entry['lead']; $content = str_replace("'", "'", $content); $title = str_replace("'", "'", $entry['titr']); $content = strip_tags($content); $title = strip_tags($title); //$content = htmlspecialchars($content); //$title = htmlspecialchars($title); $title_for_url = str_replace(' ', '-', $entry['titr']); $link = "http://$host/shownews?public_news=".$entry['id'].'&title='.$title_for_url; $pub_date = date("r", strtotime($entry['news_date'].' '.$entry['news_time'])); //$thumb = htmlspecialchars("http://www.new.airport.ir/home?p_p_id=NetFormGetFile_WAR_NetForm&p_p_lifecycle=2&p_p_resource_id=getFile&_NetFormGetFile_WAR_NetForm_t=9119&_NetFormGetFile_WAR_NetForm_recordId=50221&_NetFormGetFile_WAR_NetForm_fieldId=36345&_NetFormGetFile_WAR_NetForm_fileName=upload_771_00005159.jpg&_NetFormGetFile_WAR_NetForm_extDir=10201/4606"); echo " $content $link $pub_date "; } echo " "; pg_free_result($entries); pg_close($con); ?>