Warning: implode() [function.implode]: Invalid arguments passed in /var/www/vhosts/11v11.com/httpdocs/api/controllers/matches.php on line 80
MYSQL ERROR
select
EX_001_COMPETITION_ID as compID,
EX_001_NAME as comp,
EX_004_ID as id,
EX_004_HOMETEAM as home,
EX_004_AWAYTEAM as away,
EX_004_DATE as date,
DATE_FORMAT(EX_004_DATE, '%d %b %Y') as dateFormatted,
concat(DB_004_HOMESCORE,'-',DB_004_AWAYSCORE,
if( DB_004_HOMEPENS>0 or DB_004_AWAYPENS>0,concat(' (',DB_004_HOMEPENS,'-',DB_004_AWAYPENS,')'),'')) as score
,
CASE
WHEN EX_002_HOMETEAM_ID = 135 THEN
CASE
WHEN DB_004_HOMESCORE = DB_004_AWAYSCORE THEN 'D'
WHEN DB_004_HOMESCORE > DB_004_AWAYSCORE THEN 'W'
WHEN DB_004_HOMESCORE < DB_004_AWAYSCORE THEN 'L'
END
WHEN EX_002_AWAYTEAM_ID = 135 THEN
CASE
WHEN DB_004_AWAYSCORE = DB_004_HOMESCORE THEN 'D'
WHEN DB_004_AWAYSCORE > DB_004_HOMESCORE THEN 'W'
WHEN DB_004_AWAYSCORE < DB_004_HOMESCORE THEN 'L'
END
END as resultStatus from EX_004_MATCH, EX_001_COMPETITION where EX_001_COMPETITION_ID = EX_001_ID and (EX_002_HOMETEAM_ID in (135) or EX_002_AWAYTEAM_ID in (135)) and EX_004_DATE <="2012-02-13" and (EX_002_HOMETEAM_ID="135" or EX_002_AWAYTEAM_ID="135") and EX_001_COMPETITION_ID in () or EX_001_COMPETITION_ID = 1 order by EX_004_DATE
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 ') or EX_001_COMPETITION_ID = 1 order by EX_004_DATE' at line 29