Warning: Undefined array key "avd" in /customers/0/d/a/hemmingstad.no/httpd.www/cg/program_dato2.php on line 18 Warning: Undefined array key "avd" in /customers/0/d/a/hemmingstad.no/httpd.www/cg/program_dato2.php on line 27 Warning: Undefined variable $dato_now in /customers/0/d/a/hemmingstad.no/httpd.www/cg/program_dato2.php on line 34
object(PDOStatement)#3 (1) { ["queryString"]=> string(718) "SELECT TIME_FORMAT( fra, '%H%i' ) fra, TIME_FORMAT( start , '%H%i' ) start , TIME_FORMAT( til, '%H%i' ) til,time_to_sec( (if(start>fra,start,fra))) start2 , TIME_TO_SEC( time(til)) til2, (select mttype from hks_avtaler d4 where d4.ida=d1.ida and d4.avdeling=) mttype, (select beskrivelse from hks_avtaler_txt d5 where d5.ida=d1.ida limit 1) txt, ressurs, d2.navn Rom, kunde, IF( d3.forening > '', d3.forening, CONCAT( fornavn, ' ', etternavn ) ) Navn FROM `hks_data` d1, hks_ressurser d2, hks_kunder2 d3 WHERE d2.id = d1.ressurs AND d3.id = d1.kunde AND DATE( fra ) = '2024-04-18' AND d3.type =1 AND d2.avdeling = and d2.displ_dplan =1 AND avlyst=0 and d1.kunde !=785 and time(fra) > '07:59:00' ORDER BY START " }Fatal error: Uncaught Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') mttype, (select beskrivelse from hks_avtaler_txt d5 where d5.ida=d1.ida lim...' at line 4SELECT TIME_FORMAT( fra, '%H%i' ) fra, TIME_FORMAT(