<?php
$sql = "SELECT vysledky2.cisloobch, vysledky2.datum, vysledky2.vysledek, dealersdata.nazevobch, dealersdata.mesto, dealersdata.zeme, psc, " +
" (CASE WHEN prod_smlouva = 'True' OR serv_smlouva = 'True' THEN 'Ano' ELSE 'Ne' END) as skoda," +
" (CASE WHEN prod_smlouva_v = 'True' OR serv_smlouva_v = 'True' OR serv_smlouva_a = 'True' OR prod_smlouva_a = 'True' OR serv_smlouva_n = 'True' OR prod_smlouva_n = 'True' OR serv_smlouva_s = 'True' OR prod_smlouva_s = 'True' THEN 'Ano' ELSE 'Ne' END) as ost_koncern" +
" FROM vysledky2 JOIN" +
" (select cisloobch, max(datum) as datum from vysledky2 where dotazid = 94 and vysledek not like '%ORA%' group by cisloobch) as nejvyssi"+
" on vysledky2.cisloobch = nejvyssi.cisloobch and vysledky2.datum = nejvyssi.datum"+
" JOIN dealersdata on vysledky2.cisloobch = dealersdata.cisloobch"+
" WHERE dealersdata.vyrazeny = 'False' AND jiny != 'True' ";
echo $sql;
Fatal error: Uncaught TypeError: Unsupported operand types: string + string in /in/FZbVG:3
Stack trace:
#0 {main}
thrown in /in/FZbVG on line 3
Process exited with code 255.
Warning: A non-numeric value encountered in /in/FZbVG on line 3
Warning: A non-numeric value encountered in /in/FZbVG on line 3
Warning: A non-numeric value encountered in /in/FZbVG on line 4
Warning: A non-numeric value encountered in /in/FZbVG on line 5
Warning: A non-numeric value encountered in /in/FZbVG on line 6
Warning: A non-numeric value encountered in /in/FZbVG on line 7
Warning: A non-numeric value encountered in /in/FZbVG on line 8
Warning: A non-numeric value encountered in /in/FZbVG on line 9
0