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-03-19'
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(
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-03-19'
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 in /customers/0/d/a/hemmingstad.no/httpd.www/cg/class/database.php:55 Stack trace: #0 /customers/0/d/a/hemmingstad.no/httpd.www/cg/program_dato2.php(92): Database->getRows('SELECT TIME_FOR...') #1 {main} thrown in /customers/0/d/a/hemmingstad.no/httpd.www/cg/class/database.php on line 55