<?php header('Content-Type: text/xml'); ?>
<?php
 echo '<?xml version="1.0" encoding="ISO-8859-1" ?>';
?>
<!DOCTYPE rss PUBLIC '-//Netscape Communications//DTD RSS 0.91//EN'
 'http://my.netscape.com/publish/formats/rss-0.91.dtd'>
<rss version="0.91">

<?php

// Connect to the database server
include("links/connect.php");

// When clicked, this link will load this page with the order submission form displayed.

$query = "SELECT ID, Site, URL, Comments , Keywords FROM links ";

$where = "";

$order = " ORDER BY ID DESC limit 5" ;

$query = $query.$where.$order;

$query = "SELECT nombre, actividad, nombrenor FROM buscaempresas WHERE created IS NOT NULL ORDER BY Created DESC limit 10";


$result=mysql_query($query) or die("Fallo en la consulta $query!");
$num = mysql_num_rows($result);

print "<channel>\n";
print "<title>Ultimas empresas dadas de alta en GV Soft</title>\n";
print "<link>http://www.gvsoft.com/empresas.php/</link>\n";
print "<description>Lista de las ultimas empresas dadas de alta</description>\n";
print "<language>en-us</language>\n\n";




for ($i=0;$i < mysql_num_rows($result);$i++) {

       	$row = mysql_fetch_row($result);
//	print "<td class=dir>$row[0]: <a href=$row[2] class=url>$row[1]</a><small><em><b> ($row[4])</b></em> $row[3]</small></td>";
//$query = "SELECT ID, Site, URL, Comments , Keywords FROM links ";


     print "<item>\n";
     print "\t<title>".$row[0]."</title>\n";
//     print "\t<link>http://www.gvsoft.com/empresa-detalle.php?nombre=".urlencode($row[0])."</link>\n";
     print "\t<link>http://www.gvsoft.com/empresa-detalle/nombrenor/".urlencode($row[2])."</link>\n";

     print "\t<description>".$row[1]."</description>\n";
     print "</item>\n\n";
}

print "\n</channel>\n";
print "</rss>\n";

?>

