IJSHOCKEYTEAM HEERENVEEN

Error in query: SELECT `ID`, (TO_DAYS(NOW())-TO_DAYS(`Date`)) AS `Diff` FROM `games` WHERE `CompID` IN (1044) AND `Status` NOT IN ('/', '!', '-', '0', '1', '2', '3', '4', '5', '6', '7','8', '9', '#') AND ((`TeamA` IN (447)) OR (`TeamB` IN (447) OR (`TeamC` IN (447)))AND `Date`>= '22-07-01' AND TO_DAYS(`Date`)-TO_DAYS(NOW()) <= '6' ORDER BY `Date` ASC, `Nr`, `Location`, `TeamA`
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 'ORDER BY `Date` ASC, `Nr`, `Location`, `TeamA`' at line 1

Tracing information:
File: /home/nijbuser/webapps/app-nijb/httpdocs/result.ajax.php Line: 70 Function: kompsos_query(0=SELECT `ID`, (TO_DAYS(NOW())-TO_DAYS(`Date`)) AS `Diff` FROM `games` WHERE `CompID` IN (1044) AND `Status` NOT IN ('/', '!', '-', '0', '1', '2', '3', '4', '5', '6', '7','8', '9', '#') AND ((`TeamA` IN (447)) OR (`TeamB` IN (447) OR (`TeamC` IN (447)))AND `Date`>= '22-07-01' AND TO_DAYS(`Date`)-TO_DAYS(NOW()) <= '6' ORDER BY `Date` ASC, `Nr`, `Location`, `TeamA`;)
File: /home/nijbuser/webapps/app-nijb/httpdocs/result.ajax.php Line: 223 Function: showResults(0=Array;1=447;)

User: Unknown (not logged in)
Host:
Addr: 34.240.189.193
The page you asked for generated an error and cannot be displayed. This error has been reported to the system-administrator and will in general be corrected within 24 hours.

Bekijk programma