<br />
<b>Notice</b>:  Undefined index: search in <b>/var/www/html/prevent/api/mydoctor/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, 
	person.s_rank,
	rank.name as rankname,
	person.s_person,
	person.fname as fname,
	person.sname as sname,
	person.s_navydepart,
	navydepart.descript as navydepartname,
    visit.visitdate as visitdate,
    
    checkspirometry.s_checkspirometry ,
    checkspirometry.s_visit,
    checkspirometry.bestfvc,
    checkspirometry.fvc,
    checkspirometry.fev1,
    checkspirometry.fev1p,
    checkspirometry.mmf,
    checkspirometry.pef,
    checkspirometry.summary
from
    checkspirometry,
    visit,
    person ,
	rank,
	navydepart
where 
	person.s_navydepart      = navydepart.s_navydepart AND
	person.s_rank			 = rank.s_rank 	AND
	person.s_person		     = visit.s_person AND
	checkspirometry.s_visit	 = visit.s_visit AND
	person.s_person 		 =    
    ] -&gt; You have an error in your SQL syntax; check the manual that corresponds to y in <b>/var/www/html/lib/nmd15/db/mySql/DbMySql.php</b> on line <b>30</b><br />