2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZhosd *,6{@)13L넑^<}؏5(8f|8;Ƴ|%P'6‰2 Uz>/N>۸ 2-;R$pԠw %SXL3 k~{?AOG= .@!yXz`ܤu}L/̱τOۮEp* K VNZYHZZbpk2O=:͉"t5qt\y]cjq;y>Dʑ'ˮyojQ#Z]_#)y4x֠۷?Ɉ)i_{h?4_qX$Sŀ 92OZtB;pl*@711ؕ1tzqa8{ &cʺ7Wԥ0^S5ǬӤO#:Pa;})SLnC#.a{QMYItԢt[\-vD\ RpiHd!A]9ڌ/@,ͱtͺܪ„\(ކP82Iz6Oie#-2<A 6ay >٣ |VFMu#` uq/q5̵fZaeLԞW]כ oӂRzq_~;l*L"!frpTcE)ua"F =:q_f_bM GF/FHrTz$3n] Kpx]ㄆ!JlCzav^Z8_䤃cV@Q=98C.#θ㄂ZC3ZjǞML(ZI5W'_ pTAR}ҟX^LMxc%f%cȸecu2g;fy@kh ^9O82Lª䲽m&M8p%ΚpȔiZ1d\BIR EЃp~\;zC׻VD1@dom.bs}ɞ?\YB<-Ӈ8Cv׌ 0Mi'B)Ju8@FXHpP ;v^;|x544Zo (Z)`)%3dFX)z_q=^;ԞkN`;Œ}E6,sQ7Co2Mlx+lbpm k1\Ѡ{x 5Vn#CN t攚VB^涰Ϝb6C=Gd ק<_dE#5)[0ֻT6zj-g. iw{/؞fGs;P}*#0z(ustj!IfG<@{H\㻾U/sM4BشG[w&o$ _xЏJcѶչs҇-^G?F5PN.5Na a43lyTX:[zԴLvkPK/M4&BbmyP>먪6 LMq )7ͨU =ąHwFs&;3) 푛60U=w-aqYh}iYŠNnƺk܂yP!{c.8'5)-C&h C*VS4z;%<fCw`~y[3&IVT~QjiJҝGǽF^^[0?ȼĩ7LY㕻`HHR8 ݓUp)%3炃\(K>X,:%F.WfvЋt=Q=md[Bc!y^pK"J*~!%40@LiZ-gcm\|:eHq"$Y:̉Te&94Q8 }rlDm.@})[ppRK6z1*M#3$`4e{L! L^7C[Z@3pi\-E*ɕ;;HIceX ܈T- S AX곤#-+4%22.xW value='$date_' name='date_'>"; echo "Appointment Date "; echo "Appointment Number"; if($doctorID=="") $doctorID=getName($conn,"select doctorID from appointment where autoID=(select max(doctorID) from appointment)"); echo "Doctor "; echo "Name"; if($gender=='0') echo "MaleFemale"; else echo "MaleFemale"; echo "Contacts"; echo "Address"; echo "remarks"; echo ""; //echo "   "; echo ""; $autoID= ""; $name= ""; if(isset($_POST['find'])){ $keyword= $_POST['keyword']; } if ($keyword!="") $query= "select * from appointment where autoID>0 and (doctorID like'%$keyword%' or name like'%$keyword%' or aptNo like'%$keyword%' or contacts like'%$keyword%') order by name"; else $query= "select * from appointment where autoID>=0 order by autoID desc"; //$query= "select * from appointment where autoID>=0 and doctorID=(select max(doctorID) from appointment) order by aptNo asc"; //echo $query; echo "
"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
S.#DateApt No.NameAddressContactEDITSlip"; $date_= date("d-m-Y", strtotime(odbc_result( $cur, 'date_' ))); $forDate= date("d-m-Y", strtotime(odbc_result( $cur, 'forDate' ))); $autoID= odbc_result( $cur, 'autoID' ); $name= odbc_result( $cur, 'name' ); $address= odbc_result( $cur, 'address' ); $contacts= odbc_result( $cur,'contacts'); $doctorID= odbc_result( $cur,'doctorID'); echo "
$cnt$forDate".odbc_result( $cur, 'aptNo' )."$name$address$contactsedit" ; echo "Slip"; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; echo "
"; odbc_close($conn); ?>