' ), array ( '&' , '"', ''' , '<' , '>' ), $string ); } // Connecting, selecting database $dbconn = pg_connect("host=localhost dbname=customers8 user=postgres ") or die('Could not connect: ' . pg_last_error()); // Performing SQL query $query = 'select prrfnbr, txname, txsdesc, to_char(pravdate,\'Dy, DD Mon YYYY\') as hmerom from product left outer join prodrel on plcprnbr=prrfnbr left outer join txts on txprnbr=prrfnbr where prpub=1 and plpprnbr=26226 and txlgnbr=\'el\' order by pravdate desc limit 20'; $result = pg_query($query) or die('Query failed: ' . pg_last_error()); // Printing results in HTML header('Content-type: text/xml', true); print "\n"; print "\n"; print " \n"; print " "; print " http://www.yen.gr"; print " Επικαιρότητα (RSS) - Τελευταία γεγονότα"; print " el"; print " Copyright 2007, MMM,A&IP Press Office"; print " egov@yen.gr (MMM,A&IP eGov Office)"; while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) { print " "; print " \n"; print " http://www.yen.gr/wide/yen.chtm?prnbr=".$line["prrfnbr"]."\n"; print " ".xmlentities($line["txsdesc"])."\n"; print " ".$line["hmerom"]."\n"; print " "; } print " \n"; print " \n"; // Free resultset pg_free_result($result); // Closing connection pg_close($dbconn); ?>