Vaig fer aquestes línies per cada portal:
<div class="block block-aggregator" id="block-aggregator-feed-11">
<h2 class="title">La Pobla de Benifassà</h2>
<div class="content"><div class="item-list"><ul>
<?php
$db=mysql_connect("SERVIDOR_BBDD","USUARI_BBDD","PASS_BBDD");
mysql_select_db("NOM_BBDD",$db);
$result = mysql_query("SELECT title, vid from node LEFT JOIN i18n_node ON i18n_node.nid=node.nid WHERE i18n_node.language='es' AND node.type='story' ORDER BY node.created desc limit 2;",$db);
while($myrow = mysql_fetch_array($result))
{ ?>
<li><a href="http://www.lapobladebenifassa.es/node/<?php echo ($myrow["vid"]);?>"><?php echo utf8_encode($myrow["title"]);?></a></li>
<?php } ?>
<?php mysql_close($db); ?>
</ul></div><div class="more-link"><a href="http://www.lapobladebenifassa.es/rss.xml" title="Sindica RSS"><img src="http://sepam.dipcas.es/portals/misc/feed.png" alt="Sindica RSS" /></a></div></div>
</div>
Envia un nou comentari