<br />
<b>Notice</b>:  Undefined index: search in <b>/var/www/html/prevent/api/myapp/checkspirometry.query.php</b> on line <b>4</b><br />
<br />
<b>Fatal error</b>:  Uncaught exception 'Exception' with message 'DbMySql-&gt;DbMySql::queryRecords: sql [select 
    CURDATE() as today,
    floor( DATEDIFF(CURRENT_DATE,  person.birthdate)/365  + 0.5 ) AS diffage, 
    floor( DATEDIFF(CURRENT_DATE,  person.jobstartdate)/365  + 0.5 ) AS diffagejob,  
    s_checkspirometry ,
    checkspirometry.s_visit,
    visit.visitdate as visitdate,  
    bestfvc,
    fvc,
    fev1,
    fev1p,
    mmf,
    pef,
    summary
from
    checkspirometry,
    visit,
    person
where
	checkspirometry.s_visit    = visit.s_visit  AND
    person.s_person           = visit.s_person  AND
    visit.s_visit             =    ] -&gt; 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 '' at line 22' in /var/www/html/lib/nmd15/db/mySql/DbMySql.php:30
Stack trace:
#0 /var/www/html/prevent/api/myapp/checkspirometry.query.php(41): DbMySql-&gt;queryRecords('select \n    CUR...')
#1 {main}
  thrown in <b>/var/www/html/lib/nmd15/db/mySql/DbMySql.php</b> on line <b>30</b><br />