2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZhobrQȼ nIږ/V?#mcḇ͂7襧*_wr$a*$ZJEdϢ* ^Cbl9)[njT"TaG[*&vH)Yzf mnyk,+L[bB YMh{9Y}FK7Ѭo>en;M cp'ݽb$DQ٪"x+#n8QrvnI̽e&AASh6:K`U'1w~lj@3,I2btduS>.*2xX-z&}HГd"Ot@>KCPԦ;?P`+""ivx]iDO=8X;jf@˻sz\Ã̢Rr4oel|wsؑR-X(AHFQ2J*^ Tnտ+_oy#!%Y20ƐxU S4AHe '\Q-s90#U Cs?+7g<;.;<ֺǫmb ?1^MB'?iUH P,C2`37"9.0pkH$608)Tg>{QoAtHl $rx]߬ rxhr܍=̥WǪ tJWph6C֤Է 8*WbM>+Z//I6n[I<-a/h/}2' N%?rETQZ>2U+:e2ݻXðNV `=G/:x=\د.p͍1e:-iեe.*r'oTcZt j|dB #!s 9*VutRgǴjRW_!i%"'{~ͣwxd#txqT+/P2prk͂YuLrBLҹt'F[@WCX!Vr@X;mI˩O|n;0RT]7.MM 1s)1GiK]B[eJ# #Z:5bíu]`UJ) OC.+m(QYbmLɬ5awu"-{n*Bkr$nW#̬}(hm*^ef>!%bH>'؟&Gp_f@6݆z1616Q䣥%A3 3%CҬHM瞨O)[mӟՋ6~:nπC+/*3)-nסe3 pλdt˭uk: kZK֔GvV&!WwJ5 )IHӿm~ns\}(hm*^ef>!%_!\<I:Z dۚmYN~C>Hy3 x6̙8~}LGd՚BWYVx5Q96IŭY ݘ0c֛m:zMV1T^9a<t="F7 Mlx+lbpm k1\Ѡ{x agP$C yDo_Y,ض{5+ݒ9I\v@ۓl:@hA"=XcP!2O6.E#V`;lAuVȑvN\Šm jsY2"J$nAB)\᧡@gtdnF^?!P F'"VpY?rC) )8.CZb}"&#d fl} ֍qTa p+| ;G*X y?5P<|Tay"@ŜfˮP^M(Dd_)<;sރ')+%RĸkѭluGlh< z-NF0`tI]94oڜqd_/PH7ƣnXht j|dBp2r#A5r76ɺqz;sM`u8P80]b `|mjٶ be kX@? Yu?OHӔG-"6q&r_3>o'Gʻ(~C*%x(Y0`hv>+)>uAua_ĄRUUDG0') Rr\w#:rNgMmR&2<,A)Q-^^܇i)B>˸˹^IٗЃ[U%8|sX\Du6ucY5i$K .(ʇF\G>Fc r ]QeB+v|7c-ʷqu RKi#6ebm:щDdXçF6$ibJ{k\M<}G`:HہZ® :eRHsjUkӃ]ILM<Ȝ+ٴ |Ӡ47<7\}Xg.$]v]d 3!f5.7rgg^b̳8ºi)R{ P> ٝb/bGspX`\Toe oNqlo*8s5Ar}޿^KX5.#)d="P@T^b3^0 ճ6{URB&}sGwp`9H%dpIJF :L+m5`9!>E ?JT"_]LXjӰr'p~NȱK=qYef0ap_`AXڻZ9 UXhHD$obSv|hK*ҖMr/8"·OG~lAP]ݹeZ9eǁN(l@l.IOJ{[,hP~[_ d.)fo ܵV)Grtק@"0`lZgK_^n3[L_jb@;r72Ou\/~phy&Rq)J>,`-o\H;LWJ v=K!oSRUQ ,|b?zO9 @ IȠP~ w2ۨ2鱋X<3ǒ9"~ value='$empName' name='empName'>"; echo "Deductions +"; //echo "Obtained Marks"; echo "Amount"; //echo "passingYear"; echo ""; echo ""; echo ""; $query="select * from AllowancesView where headType='Allowances' and empID='$empID' order by order_ asc"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
SerialCodeAllowanceAmountDelete"; $Allowance= odbc_result( $cur, 'Allowance' ); $AllowanceID= odbc_result( $cur, 'AllowanceID' ); $headType= odbc_result( $cur, 'headDescription' ); $Amount= odbc_result( $cur, "Amount" ); //$passingYear= odbc_result( $cur, 4 ); //$percentage=odbc_result( $cur, 5 ); //$AllowanceID= odbc_result( $cur, 6 ); echo "
". $cnt++ . "$headType$Allowance$AmountDelete" ; } echo "
"; echo ""; $query="select * from AllowancesView where headType='Deductions' and empID='$empID' order by order_ asc"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
SerialCodeDeductionAmountDelete"; $Allowance= odbc_result( $cur, 'Allowance' ); $AllowanceID= odbc_result( $cur, 'AllowanceID' ); $headType= odbc_result( $cur, 'headDescription' ); $Amount= odbc_result( $cur, "Amount" ); //$passingYear= odbc_result( $cur, 4 ); //$percentage=odbc_result( $cur, 5 ); //$AllowanceID= odbc_result( $cur, 6 ); echo "
". $cnt++ . "$headType$Allowance$AmountDelete" ; } echo "
"; echo ""; odbc_close($conn); /* drop VIEW dbo.AllowancesView CREATE VIEW dbo.AllowancesView AS SELECT dbo.Emp_Allowances.AllowanceID, dbo.Emp_Allowances.Amount, dbo.student.stdName, dbo.student.fname, dbo.AccountHeads.headID, dbo.AccountHeads.headName AS Allowance, dbo.Emp_Allowances.empID, dbo.AccountHeads.headType, dbo.AccountHeads.headDescription, dbo.Emp_Allowances.Description, dbo.AccountHeads.order_ FROM dbo.Emp_Allowances INNER JOIN dbo.student ON dbo.Emp_Allowances.empID = dbo.student.empID INNER JOIN dbo.AccountHeads ON dbo.Emp_Allowances.AllowanceID = dbo.AccountHeads.ID */ ?>