Warning: Cannot modify header information - headers already sent by (output started at /home/tslwebreg/public_html/events.php:16) in /home/tslwebreg/public_html/phpgrid/lib/inc/jqgrid_dist.php on line 4187
Couldn't execute query. 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 'GROUP BY e.lEventID, e.sName, e.sLocation, e.sStatus, e.dtCreatedOn, e.dtStart, ' at line 1 - Select e.lEventID, e.sName, e.sLocation, e.sStatus, e.dtCreatedOn, e.dtStart, e.dtEnd, count(r.lRegID) as Registrants From Events as e LEFT JOIN Registrants as r on r.lAccountID = e.lAccountID and r.lEventID = e.lEventID where e.lAccountID = GROUP BY e.lEventID, e.sName, e.sLocation, e.sStatus, e.dtCreatedOn, e.dtStart, e.dtEnd LIMIT 1 OFFSET 0