Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/hogueschool/public_html/schedule.html.php on line 9Bob Hogue Florida Real Estate License School Classroom Course Schedule

SELECT sum(a.joiner) testnum FROM (SELECT 1 joiner FROM locations l JOIN `Schedule` s on left(s.location,3) = left(l.loccode,3) and s.`start` > now() and s.course in ("3I","3B") and s.bob is null and s.tentative is null GROUP BY s.location ) a