test

Make New Notification

‘;

echo ‘Below is a list of all notifications you have sent. Please remember that notifications must be kept on file for a period of 4 years.
‘;

echo ‘

‘;
echo ‘

‘;

$query = “SELECT * FROM Notices
JOIN Schools
ON Notices.NoticeSchoolIDFK = Schools.SchoolID
JOIN Pesticides
ON Notices.PesticideID1 = Pesticides.PesticideID
ORDER BY NoticesentID DESC”;

$result = mysqli_query($dbc, $query);
while ($row = mysqli_fetch_array($result)) {
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
}
echo ‘

Notice ID	School	Area	Reason	Pesticide	Date2
‘ .$row[‘NoticeSentID’] .’	‘.$row[‘SchoolName’] .’	‘ .$row[‘NoticeArea’] .’	‘ .$row[‘NoticeReason’] .’	‘ .$row[‘PesticideName’] .’	‘ .$row[‘NoticeDateApply’] .’

‘;
echo ‘‘;
//end listing sequence
mysqli_close($dbc);
?>