Notice: Undefined index: start_date in /var/www/html/prevent/api/myreport - Copy/report/division_navydepart--bak.php on line 4

Notice: Undefined index: end_date in /var/www/html/prevent/api/myreport - Copy/report/division_navydepart--bak.php on line 5

Notice: Undefined index: navydepart in /var/www/html/prevent/api/myreport - Copy/report/division_navydepart--bak.php on line 6

Notice: Undefined variable: division in /var/www/html/prevent/api/myreport - Copy/report/division_navydepart--bak.php on line 28

Fatal error: Uncaught exception 'Exception' with message 'DbMySql->DbMySql::queryRecords: sql [SELECT navydepart.name AS navydepartname, person.s_navydepart AS name, person.division, COUNT(*) AS count FROM person, navydepart WHERE person.s_navydepart = navydepart.s_navydepart AND firstdate between '' and '' division = GROUP BY person.s_navydepart ] -> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'division = GROUP BY person.s_navydepart' at line 12' in /var/www/html/lib/nmd15/db/mySql/DbMySql.php:30 Stack trace: #0 /var/www/html/prevent/api/myreport - Copy/report/division_navydepart--bak.php(33): DbMySql->queryRecords('SELECT \n\tnavyde...') #1 {main} thrown in /var/www/html/lib/nmd15/db/mySql/DbMySql.php on line 30