<br />
<b>Notice</b>:  Undefined index: search in <b>/var/www/html/prevent/api/mydoctor/personvisitcheckspirometry.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 
        visit.entrydate             as 0entrydate,
        checkspirometry.bestfvc     as 1_bestfvc,
        checkspirometry.fvc         as 2_fvc,
        checkspirometry.fev1        as 3_fev1,
        checkspirometry.fev1p       as 4_fev1p,
        checkspirometry.mmf         as 5_mmf,
        checkspirometry.pef         as 6_pef,
        checkspirometry.summary     as 7_summary    
from 
		visit, checkspirometry ,person
where
		visit.s_visit 		  =   checkspirometry.s_visit   AND
		person.s_person	      =   visit.s_person     AND
		person.s_person 	  =         ] -&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 15' in /var/www/html/lib/nmd15/db/mySql/DbMySql.php:30
Stack trace:
#0 /var/www/html/prevent/api/mydoctor/personvisitcheckspirometry.query.php(30): DbMySql-&gt;queryRecords('select \n       ...')
#1 {main}
  thrown in <b>/var/www/html/lib/nmd15/db/mySql/DbMySql.php</b> on line <b>30</b><br />