SELECT MONTH(datum) as honap, DAY(datum) as datum, TIME_FORMAT(datum, '%H:%i') AS ido, DAYOFWEEK(datum) as nap, musor.evad_id as evad, musor.id as mid, musor.datum as datum2, musor.jegylink, musor.jegy_db, musor.zart, musor.berlet, musor.fuzet, musor.fuzet_eng, musor.jegyhu_aktiv, musor.jegyhu_statusz, musor.jegyhu_id, repertoar.id as rid, repertoar.cim, repertoar.szerzo, helyszin.nev as helyszin1, helyszin.nev_eng as helyszin2 from musor
inner join repertoar on musor.repertoar_id=repertoar.id
inner join helyszin on musor.helyszin=helyszin.id
where repertoar.aktiv=1 and repertoar.nyelv_id=1 and year(musor.datum)= and month(musor.datum)=10 order by datum2 - - 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 month(musor.datum)=10 order by datum2' at line 4 Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /vhosts/web/arvense/www.ismersz.hu/operett/class/db.php on line 48 Budapesti Operettszínház
