News Articles

Most recent:

{{ .Title }} {{ .Params.type }}

<?php

$sql = “SELECT nr.nid, n.title, concat(substring(nr.body,1,300), ‘…’) as body, u.dst from {node_revisions} nr LEFT JOIN {node} n on nr.nid=n.nid LEFT JOIN {url_alias} u on nr.nid = substring(u.src,6) where substring(u.dst,1,16)=‘news_articles/20’ order by u.dst desc limit 1”;

$result = db_query($sql);

$rec = db_fetch_array($result);

$output = “” .check_plain($rec[‘title’]) .”
”;

$output .= check_markup($rec[‘body’]);

unset($result);

$output .=”

Archives

”;

$sql = “SELECT nr.nid, n.title, u.dst, date_format(substring(u.dst,15,10),‘%M’) as mo, date_format(substring(u.dst,15,10),‘%Y’) as ye from {node_revisions} nr LEFT JOIN {node} n on nr.nid=n.nid LEFT JOIN {url_alias} u on nr.nid = substring(u.src,6) where substring(u.dst,1,16)=‘news_articles/20’ order by u.dst desc”;

$result = db_query($sql);

$currMo=“None”;

$currYear = “2101”;

$output.=”
”;

while($nws = db_fetch_array($result)){

if($currMo != $nws['mo'] || $currYear != $nws['ye'] )

{

    if( $currMo != "None" )

        $output .= "</ul>"; //only need to close list AFTER 1st time

    $currMo = $nws['mo'];

    $currYear = $nws['ye'];

    $output .= "<b>" .$currMo .", " .$currYear ."</b></br><ul>";

}

 $nws['dst'] = "/" .$nws['dst'];    //need leading slash for absolute

 $output .= "<li><a href=\"" .$nws['dst'] ."\"><b>" .check_plain($nws['title']) ."</b></a> " .$nws['dt'];

 $output .= "</li>";

}

$output.=”

echo $output;