";
//Only selects articles from SECTOR C
$sql_sector = "SELECT ssbriefid, headline, nicedate from subsector_articles where sector1 = \"C\" OR sector2 = \"C\" OR sector3 = \"C\" OR sector4 = \"C\" or sector5 = \"C\" ORDER BY longdate ASC";
$result_sector = mysql_query($sql_sector);
if ($row_sector = mysql_fetch_array($result_sector)) {
echo"";
$yearnow = date("Y");
echo "Year ".$yearnow . "";
$sql = "SELECT ssbriefid, headline, nicedate from subsector_articles WHERE (longdate LIKE \"$yearnow%\") AND sector1 = \"C\" OR sector2 = \"C\" OR sector3 = \"C\" OR sector4 = \"C\" or sector5 = \"C\" ORDER BY longdate ASC";
$result = mysql_query($sql);
unset($yr);
while ($row = mysql_fetch_array($result))
{
$headline = trim($row[1]); // stripping whitespaces & other chars from the beginning & end of the HEADLINE FIELD
$date = $row[2];
$ssbriefid = $row[0];
$list = $headline." - ".$date;
// To list each record with a corresponding link to it...
//echo "$list
";
echo "| $headline - $date |
";
}
}
echo "
";
echo "
";
include('txt/centerend.txt');
include('txt/bottombar.txt');
?>