|
//Top Heading Bar in Dark Blue
echo "MALAYSIAN ECONOMY & SECTORS | ";
//Only selects articles from SECTOR A
$sql_sector = "SELECT ssbriefid, headline, nicedate from subsector_articles where sector1 = \"A\" OR sector2 = \"A\" OR sector3 = \"A\" OR sector4 = \"A\" or sector5 = \"A\" 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 = \"A\" OR sector2 = \"A\" OR sector3 = \"A\" OR sector4 = \"A\" or sector5 = \"A\" 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');
?> | | |