require 'connection.php';

$getCirculars="SELECT filepath, description, DATE_FORMAT(dateuploaded, '%d %M %Y') FROM documents WHERE grouptype = 'annual_reports' AND datedeleted IS NULL AND fyfrom = 2016 AND fyto = 2017 ORDER BY id DESC";
//$getCirculars="SELECT filepath, description, DATE_FORMAT(dateuploaded, '%d %M %Y') FROM documents WHERE grouptype = 'policies' ORDER BY id DESC";
$exeCirculars = mysql_query($getCirculars);
if($exeCirculars){
if(mysql_num_rows($exeCirculars) == 0) echo "

No Annual Reports for 2016/17 FY

";
else{
$tb = "";
$tb .="

";
$i =0;
while($row = mysql_fetch_array($exeCirculars)){
$i++;

$filepath=stripcslashes($row[0]);
$description=stripcslashes($row[1]);

$tb .="

";
}
$tb .= "

NO.	FILE	DESCRIPTION
$i		$description

";
echo $tb;
}
}
echo mysql_error();
?>