";
//END OF CHART INSERT
//HEADING FOR ARTICLES
echo "
ARTICLES & READINGS
";
//Only selects articles from SECTOR A
$sql_sector = "SELECT ssbriefid, headline, nicedate from subsector_articles where sector1 = \"B\" OR sector2 = \"B\" OR sector3 = \"B\" OR sector4 = \"B\" or sector5 = \"B\" ORDER BY longdate ASC";
$result_sector = mysql_query($sql_sector);
if ($row_sector = mysql_fetch_array($result_sector)) {
echo"
";
$yearnow = date("Y");
echo " ";
echo "Year ".$yearnow . "";
$sql = "SELECT ssbriefid, headline, nicedate from subsector_articles WHERE (longdate LIKE \"$yearnow%\") AND sector1 = \"B\" OR sector2 = \"B\" OR sector3 = \"B\" OR sector4 = \"B\" or sector5 = \"B\" 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 "