Warning: Undefined array key "id" in C:\xampp\htdocs\treatment_adherence\streak.php on line 8

Warning: Undefined array key "maxScore" in C:\xampp\htdocs\treatment_adherence\streak.php on line 9

Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND date >= DATE_SUB(CURDATE(), INTERVAL 3 DAY) AND total_count = 0' at line 1 in C:\xampp\htdocs\treatment_adherence\streak.php:33 Stack trace: #0 C:\xampp\htdocs\treatment_adherence\streak.php(33): mysqli->query('SELECT COUNT(*)...') #1 {main} thrown in C:\xampp\htdocs\treatment_adherence\streak.php on line 33