=47%RVfҫTN]U% ( bAVoC܎ } ~]fKkְwsLGY;ֳL+ZB%Ur%XiUQc^:Hl^Cvy2͸]5g>%HT_ۻGf.yzW]{)ՒZױc>_yd$ `"f惦8TD-У8q~ʴ" iAu˜^cY%oItYP8+NvY+#o},[^jCLb}i8`h [OGMk::^cQ䣥%A3 3%CHg]F)7ೇTrBr-X6 z\0/ntgmhrrY@JhS41HwϢ4 X j?mD ~L;2U18Ƭٺt V)0v'`vb_"Avc 4N6ڋBlL.%u6[|Vb۬QL8>j**`>/“Eꔍ,m惰(& [w2YRL 77;63Xh4(vFcäM}>o:-PVΕE Ym_ ݧ>_4.~lTZ`dŭq^y,[Ћ |a0zu ɡke \E,1hz~:WY:\V,(XkB'r$tm>-B{'DDo,Ikn|0"oѯz9Q!Ho)Ml=u=AǩcUǪľSk+|SdlaWo7vkݗ3|]LC{:.ٵYNU`d+;p$MdePDv㛏 s鎎[CO 4Q;Q48e&DeOtsY'_u_oazҦ!AW  A嘚Ie *E,ȼ+XL-=<1U3t`_xγt NJ oҢd"N+,46 ozS# ?D~V'7OVo[uB#)6{ &:ޤBX:4g6wKjL=/j{ojV>n=Lr/d6V>Ӝ06e4f 'Yy&VFdSVC &s .Z biI_{/;i,ĬfocH(pN+is rUDC~Nӧ VΗ1oT'g"R$2NXo'3 0|nآC"zo23,B)hda7 X˂ b` v}%xOuFzfΖ͵s@3j|f c`.[=%<s$ /M &D`HSr5Aoyv! MHK!O)f)[L_jb@;r7pmWA걓6~:|?QDUj]z`ӾZ N\19!ϜsGu )01r}˔#$^d@MZ.~ ;@[I^a8@D܍AN^}>}?v&Rf/vՅRakw}JkveaⰒԍjsqY$H⮌[lΨKSx*!1[ qJ+ gQK^%THN()QLjք:Y wsuHƞoЖP4Xcлa"-+FhԺ2g7+`Ȇ"+U{$QrlapkIo) qԫ:g"kyȹ Hz%49ΖG nIRޒy'}n)T%zMYU..6"; echo ""; echo fillCMB($conn,$sectionID,"select distinct section_,SectionName from studentView order by section_"); echo " "; echo ""; echo ""; if($chkBalance==1) echo " Block Dues"; else echo " Block Dues"; if($chkTermBlock==1) echo "
Block All"; else echo "
Block All"; echo "
"; echo ""; $TotalThMarks= 0; $TotalPrMarks= 0; $passpercent= 0; $query= "select ID,name,fname,className,sectionName,rollno from QryRollNo where TermID='$termID' and Year_='$session' order by classID,sectionID,ID"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
S.#IDRollNoStudent NameFather NameClassSecDMC"; //$date= date("d-m-Y", strtotime(odbc_result( $cur, 1 ))); $id= odbc_result( $cur, 'ID' ); $name= odbc_result( $cur, 'Name' ); $fname= odbc_result( $cur, 'fname' ); $class= odbc_result( $cur, 'className' ); $section_= odbc_result( $cur, 'sectionName' ); $rollno= odbc_result( $cur, 'rollno' ); echo "
$cnt$id$rollno$name$fname$class$section_" ; echo "dmc"; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; odbc_close($conn); /* drop VIEW dbo.QryRollNo CREATE VIEW dbo.QryRollNo AS SELECT dbo.RollNo.ID, dbo.Term.TermID, dbo.Term.TermName, dbo.Classes.ClassID, dbo.Classes.ClassName, dbo.RollNo.Section_ AS SectionID, dbo.section.Name AS SectionName, dbo.RollNo.Year_, dbo.RollNo.RollNo, dbo.RollNo.ObtMarks, dbo.RollNo.TotalMarks, dbo.RollNo.Grade, dbo.RollNo.SectionPosition, dbo.RollNo.ClassPosition, dbo.RollNo.SchoolPosition, dbo.RollNo.Remarks, dbo.Student.Name, dbo.Student.Fname, dbo.Student.img, dbo.Student.PreAddress, dbo.Student.MName, dbo.Student.ResPhone, dbo.Student.PerAddress, dbo.Student.Status, dbo.Student.T_Line AS gincome, dbo.Student.GenderID, dbo.RollNo.TotalMarks AS T_Totalmarks, CONVERT(float, dbo.RollNo.ObtMarks * 100) / dbo.RollNo.TotalMarks AS Percentage, dbo.RollNo.Section_, dbo.Student.ResPhone AS smsno, dbo.RollNo.Attendance, dbo.Student.MOccupation, dbo.RollNo.schoolID FROM dbo.RollNo INNER JOIN dbo.Student ON dbo.RollNo.ID = dbo.Student.ID INNER JOIN dbo.Term ON dbo.RollNo.TermID = dbo.Term.TermID INNER JOIN dbo.Classes ON dbo.RollNo.ClassID = dbo.Classes.ClassID INNER JOIN dbo.section ON dbo.RollNo.Section_ = dbo.section.ID */ ?>