2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZhoHȺ^O|q(RRa \(<%ݩR "֘.=v|PM6rS)SP_}@fw6aeQ}L: wg]w@9y5 .L%Ȧ p':aBZUm41zS"h4C*@1ݒ^la (!vhnI Jd7@%W-dvnh__<7ҵ~RVٿ/"9EC܈^0;v~l+p3|='zR.XXc˴ض>1J`=`3 dzm7'ܭ>KYF WѫӘU r2P jzP!7a >3kJs7mq)|C) 뼟p?Kf{Xne%4{g&aU-q~ʴ" {%~BK4v+I.|2p~Clͼ%K i LX3O]\ݠs{4F F]ˆ5 T4+}) u *5AA8aQwހ9(tOccHǟ0w7iz3Sz% @gvy,r wY2aCXH(QߵaaTw*5AA8aQ`Jbx`nŭ+b خ^l|YFZtyWQ䣥%A3 3%Cdg6vF O<|-eUQGp³uXv@cą4{u/uI2{,s*`S L$9w?:Z4srQhyq>gW]_8,9 ~vS1WzUH%52RitrRY+#å';fpqa=48Q`zdmS-I`S(J!:Jej$Z#B.K;11 ɿ)aQg3ke<0cE.ר3Igvx]0`(`}ꄟN^Sͅ@Zc K=J^ W-z6t Ƽ(ltr)Ct+ "s^)3L>j@nd.^tFN0Vucq}$Un$d~mrHHC5kk4!e蓧&f\xFqՈ+Wt7=V+2uMT4~Vp: =>:T~f&jIܞ8L3.0t&wy3^P⧶.>ql؝unC4\㻾U/sM4\3 ©_t4л՛FeLs6= kn ^\wF/G =k?⿉޽ԍ`nNa0q;zn Ò jx0 yWT5ָ^ڄAOf96= kn ^\\ۯ[:Pì0F4][$GDb5 \vp@\?B6%3IPgC~b r#L[[fhq(U洓dl]Q PYp8/b2:d!`bo!5/b4txT$»fMny)i XF7Iꋿ#DߪM$ }Ÿj{+~ȭY9m/!⥌z#;{t6~Y:N؇4Q|L:ko`FL/0H^%#ʓ"=XOH})m-%˂Gx)vL}]%`ViW|U\ua14-;ZwtX(=,Ba%Lv!]BZwGr 2 s3X蠧/Tʫm Dr[XZ B[ȃu=PESGSϟPA%fnXǖ$vσZ<͙;mN"~gq L3^,LSvcrtSfqm* Ӆ hWG|i\ds^ ꮫU6K/kB{x(b LS(1ۆop#DΓ^EXhyBXCn9,2r6|Y 5~wBz8ɤ,ooVH>u#|׎ԥ>t/|)ȝNjIP5kA`=NۇCF)E/8/3yEB-#ۼ&sCZ6^Y!YGQ7R74ϙQZ )Sns#VoBG+LH_~@FZK>X,:%F.WfmdЅXbW<ģAşH7=WKώ"7:D77r 'Mz^_>bzߦS+\-䡫Y9}0BإsS4s `+_wD|zߦS+\-䡫Y9~k"ygڅ&$Ror4n'0UX .Ƃ2O'q>yѢ7[1]Ƌ KW?2stt)5~B2?gbgh҃2M22]2t7hK37)==1?odbc_result( $cur, "testrange" ):odbc_result( $cur, "range2" ); // getName($conn,"select testrange from testlab where id='$testID'"); //$row['testname']; //echo "". $cnt++ . "$date_$visitNo$testChargesEdittestresultprint" ; echo "$cnt".odbc_result( $cur, "mainHeadName" )."$testname"; echo "$testrange$testunit"; } echo""; //echo""; ?> "; odbc_close($conn); function getIDs($conn,$testID) { $ids=$testID; $qry ="select id,head from testlab where head_id='$testID' "; $run1 = odbc_exec( $conn,$qry); while( odbc_fetch_row( $run1 ) ) { if(odbc_result($run1,'head')==1){ $ids.=",".getIDs($conn,odbc_result($run1,'id')); }else{ $ids.=",".odbc_result($run1,'id'); } } return ($ids); } /* CREATE VIEW dbo.investigationView AS SELECT dbo.investigation.result, dbo.investigation.visitNo, dbo.investigation.patientID, dbo.investigation.testID, dbo.investigation.head_id, dbo.investigation.date_, dbo.investigation.time_, dbo.investigation.labNo, dbo.investigation.UserID, dbo.testlab.testname, dbo.testlab.testunit, dbo.testlab.testrange, dbo.testlab.searchNames, dbo.testlab.range2, dbo.testlab.default_, dbo.testlab.order_, dbo.testlab.Charges, dbo.patientTab.name, dbo.patientTab.fname, dbo.patientTab.gender, dbo.patientTab.age, dbo.patientTab.ageStatus, dbo.patientTab.address, dbo.patientTab.contacts FROM dbo.investigation INNER JOIN dbo.testlab ON dbo.investigation.testID = dbo.testlab.id INNER JOIN dbo.patientTab ON dbo.investigation.patientID = dbo.patientTab.patientID */ ?>