toHTML(); ?>

$db, 'tabla' => 'grupo_secciones', 'id' => 'grupo', 'nombre' => 'nombre', 'id_padre' => 'grupo_padre', 'prepend_link' => 'noticias.php?grupo='); $arbol = new HTML_ArbolDB($dbdata, '/MECON/images/arbol_noticias.gif'); echo $arbol->toHTML(); ?>

format('%Y-%m-%d'); $hoy->subtractSeconds(60*60*24*7);//7 dias $fecha_limite = $hoy->format('%Y-%m-%d'); $query = "SELECT Articles.article_id, IF(Articles.publication_date > '$fecha_nuevo', 'NUEVA', null) FROM Articles, ArticlePublicationStates WHERE Articles.article_publication_state_id = ArticlePublicationStates.article_publication_state_id AND ArticlePublicationStates.publication_state_id=5 AND Articles.publication_date > '$fecha_limite' ORDER BY Articles.publication_date desc"; $result = $db->query($query); if(DB::isError($result)) die($result->getMessage("query mal hecho")); $ht = new HTML_Table(array('width'=>'600', 'border'=>'0', 'cellspacing'=>'0')); $not1 = $not2 = null; while($row = $result->fetchRow()) { $n = new noticia($row[0]); $not = new HTML_Noticia($n); if($row[1] == 'NUEVA') $not->setNuevo(true); if(is_null($not1)) $not1 = $not; elseif(is_null($not2)) { $not2 = $not; $ht->addRow(array($not1, $not2)); } else { $not1 = $not; $not2 = null; } } if(is_null($not2)) $ht->addRow(array($not1)); $ht->display(); ?>