Error. Database query failed.
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 'AND b.classid = a.parentid' at line 6
SELECT b.classid as parentheading, b.name AS description,
b.class_level as parentlevel,
a.class_level as childlevel, a.name as childdescription
FROM clsmain a, clsmain b
WHERE a.classid =
AND b.classid = a.parentid