Fehler bei SELECT s.id, CONCAT(IF(h.id=,a.name,h.name),IF(h.id=,' (A)',' (H)')) Gegner, CONCAT(s.wh,':',s.wg,' (',s.h1,':',s.g1,')') Resultat FROM `wf_spiel` s INNER JOIN `wf_liga` l ON l.id = s.liga_id INNER JOIN `wf_team` h ON h.id=s.heim INNER JOIN `wf_team` a ON a.id=s.gast WHERE (s.heim= OR s.gast=) AND s.datum<'' AND s.gespielt=1 AND s.gewertet=1 ORDER BY s.datum DESC LIMIT 10 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 'a.name,h.name),IF(h.id=,' (A)',' (H)')) Gegner, CONCAT(s.wh,':',s.wg,' (',s.' at line 2Fehler bei SELECT s.id, CONCAT(IF(h.id=,a.name,h.name),IF(h.id=,' (A)',' (H)')) Gegner, CONCAT(s.wh,':',s.wg,' (',s.h1,':',s.g1,')') Resultat FROM `wf_spiel` s INNER JOIN `wf_liga` l ON l.id = s.liga_id INNER JOIN `wf_team` h ON h.id=s.heim INNER JOIN `wf_team` a ON a.id=s.gast WHERE (s.heim= OR s.gast=) AND s.datum<'' AND s.gespielt=1 AND s.gewertet=1 ORDER BY s.datum DESC LIMIT 10 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 'a.name,h.name),IF(h.id=,' (A)',' (H)')) Gegner, CONCAT(s.wh,':',s.wg,' (',s.' at line 2Fehler bei SELECT DISTINCT s.id,DATE_FORMAT(s.datum,'%d.%m.%Y') Datum,DATE_FORMAT(s.uhrzeit,'%k:%i') Uhrzeit, CONCAT(h.name,' - ',a.name) `direkte Begegnungen`, l.liga,SUBSTR(l.saison,3,2) saison, IF(s.datum>NOW(),'-:- (-:-)',CONCAT(s.wh,':',s.wg,' (',s.h1,':',s.g1,')')) Resultat FROM `wf_spiel` s INNER JOIN `wf_liga` l ON l.id = s.liga_id INNER JOIN `wf_team` h ON h.id=s.heim INNER JOIN `wf_team` a ON a.id=s.gast WHERE ((s.heim= AND s.gast=) OR (s.heim= AND s.gast=)) ORDER BY s.datum DESC 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 s.gast=) OR (s.heim= AND s.gast=)) ORDER BY s.datum DESC' at line 9 Wiener-Fussball.at -

-
:
(:)

Zuschauer: 


Fehler: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 'a.name,h.name),IF(h.id=,' (A)',' (H)')) Gegner, CONCAT(s.wh,':',s.wg,' (',s.' at line 2 @ SELECT s.id, CONCAT(IF(h.id=,a.name,h.name),IF(h.id=,' (A)',' (H)')) Gegner, CONCAT(s.wh,':',s.wg,' (',s.h1,':',s.g1,')') Resultat FROM `wf_spiel` s INNER JOIN `wf_liga` l ON l.id = s.liga_id INNER JOIN `wf_team` h ON h.id=s.heim INNER JOIN `wf_team` a ON a.id=s.gast WHERE (s.heim= OR s.gast=) AND s.datum<'' AND s.gespielt=1 AND s.gewertet=1 ORDER BY s.datum DESC LIMIT 10 Fehler: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 'a.name,h.name),IF(h.id=,' (A)',' (H)')) Gegner, CONCAT(s.wh,':',s.wg,' (',s.' at line 2 @ SELECT s.id, CONCAT(IF(h.id=,a.name,h.name),IF(h.id=,' (A)',' (H)')) Gegner, CONCAT(s.wh,':',s.wg,' (',s.h1,':',s.g1,')') Resultat FROM `wf_spiel` s INNER JOIN `wf_liga` l ON l.id = s.liga_id INNER JOIN `wf_team` h ON h.id=s.heim INNER JOIN `wf_team` a ON a.id=s.gast WHERE (s.heim= OR s.gast=) AND s.datum<'' AND s.gespielt=1 AND s.gewertet=1 ORDER BY s.datum DESC LIMIT 10 Fehler: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 s.gast=) OR (s.heim= AND s.gast=)) ORDER BY s.datum DESC' at line 9 @ SELECT DISTINCT s.id,DATE_FORMAT(s.datum,'%d.%m.%Y') Datum,DATE_FORMAT(s.uhrzeit,'%k:%i') Uhrzeit, CONCAT(h.name,' - ',a.name) `direkte Begegnungen`, l.liga,SUBSTR(l.saison,3,2) saison, IF(s.datum>NOW(),'-:- (-:-)',CONCAT(s.wh,':',s.wg,' (',s.h1,':',s.g1,')')) Resultat FROM `wf_spiel` s INNER JOIN `wf_liga` l ON l.id = s.liga_id INNER JOIN `wf_team` h ON h.id=s.heim INNER JOIN `wf_team` a ON a.id=s.gast WHERE ((s.heim= AND s.gast=) OR (s.heim= AND s.gast=)) ORDER BY s.datum DESC