$consulta = "SELECT node_data_field_fecha_nota.field_enlace_web_value AS web, node_data_field_fecha_nota.field_fecha_nota_value AS fecha, node_data_field_fecha_nota.field_medio_value AS medio, node.type AS node_type, node.nid AS nid, node.vid AS node_vid, node_revisions.title AS node_revisions_title, node.title AS titulo, node.language AS node_language FROM node node LEFT JOIN content_type_nota_prensa node_data_field_fecha_nota ON node.vid = node_data_field_fecha_nota.vid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid WHERE node.type in ('nota_prensa') ORDER by field_fecha_nota_value DESC";
$result = db_query($consulta);
while ($fila = db_fetch_object($result))
{
echo ' [ '.$fila->fecha.' ] '.$fila->medio.' : ';
echo '';
echo ''.substr($fila->titulo, 0, 60).'';
if (strlen($fila->titulo) > 60) echo '...';
if ($fila->web != '') echo' [ link ]';
echo'
';
}
?>
English
We use cookies to improve your experience. Some are essential, others help us with analytics and embedded content.