Warning: Undefined array key "coursename" in /home/hlhsiao/public_html/acad276/classresultsv2.php on line 40

Warning: Undefined array key "roomnumber" in /home/hlhsiao/public_html/acad276/classresultsv2.php on line 41

Warning: Undefined array key "coursename" in /home/hlhsiao/public_html/acad276/classresultsv2.php on line 62

Warning: Undefined array key "coursename" in /home/hlhsiao/public_html/acad276/classresultsv2.php on line 64

Warning: Undefined array key "type" in /home/hlhsiao/public_html/acad276/classresultsv2.php on line 67

Warning: Undefined array key "type" in /home/hlhsiao/public_html/acad276/classresultsv2.php on line 69

Warning: Undefined array key "roomnumber" in /home/hlhsiao/public_html/acad276/classresultsv2.php on line 71

Warning: Undefined array key "roomnumber" in /home/hlhsiao/public_html/acad276/classresultsv2.php on line 73

Warning: Undefined array key "date" in /home/hlhsiao/public_html/acad276/classresultsv2.php on line 76

Warning: Undefined array key "date" in /home/hlhsiao/public_html/acad276/classresultsv2.php on line 78

Warning: Undefined array key "sort" in /home/hlhsiao/public_html/acad276/classresultsv2.php on line 81

Warning: Undefined array key "sort" in /home/hlhsiao/public_html/acad276/classresultsv2.php on line 82
SQL ERROR!!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 '' at line 1

---

sql:SELECT * from schedule_view WHERE 1=1 AND coursename ='' AND type ='' AND roomnumber = '' AND date > '' ORDER BY