Conférences
Submitted by april on 22 June, 2008 - 22:37
Liste de conférences:
$items = array();
$i = 0;
$sql = "select n.nid, n.title as titre, nr.teaser
from node n
join node_revisions nr on n.nid = nr.nid and n.changed = nr.timestamp
join term_node tn on n.nid = tn.nid
where n.status = 1
and n.type = 'page'
and tn.tid = 20
group by n.nid
order by n.created desc";// liste toute les conferences
$sq = db_query($sql);
while ($result = db_fetch_object($sq)) {
$i++;
$items[$i]["titre"] = $result->titre;
$items[$i]["nid"] = $result->nid;
$items[$i]["teaser"] = $result->teaser;
}
$items["nb_terme"] = $i;
/*affichage*/
/*sommaire*/
$output="
"; $output.="";
/*liste des conférences*/
$output.="";
print $output;
?>
- ";
for ($j = 1; $j <= $items["nb_terme"]; $j++) {
/* $output.="
- ".l($items[$j]["titre"]." ", "conferences", array(), null, $items[$j]["nid"], false, false)." "; */ $output.="
- ".l($items[$j]["titre"],'node/'.$items[$j]["nid"])." "; } $output.="
"; $output.="








