</div>
<!-- Average Subject mark in each Exams -->
<?
$sqlexam="select * from exams where SchoolId='$schoolid' and ClassId='$classid' and MarkUploaded='1'";
$resultexam=mysql_query($sqlexam) or die("error: ". mysql_error());
while($rowexam=mysql_fetch_array($resultexam))
{
$examid=$rowexam['ExamId'];
$examname=$rowexam['ExamName'];
$sqlportion="select * from examportion where SchoolId='$schoolid' and ClassId='$classid' and ExamId='$examid' and SubjectId='$subjectid' and NewSubjectId='$newsubjectid'";
$resultportion=mysql_query($sqlportion) or die("error examportion". mysql_error());
while($rowportion=mysql_fetch_array($resultportion))
{
$portionid=$rowportion['PortionId'];
$extraportion=$rowportion['ExtraPortion'];
$portionname=getportionname($schoolid,$portionid);
if($extraportion!="")
{
$examportionarr[]=$portionname."-$extraportion";
}
else
{
$examportionarr[]=$portionname;
}
}
$examportion=implode(',',$examportionarr);
$sectionsubjectavg=getsectionsubjectaverage($schoolid,$classid,$sectionid,$examid,$subjectid,$newsubjectid);
$nextsectionsubjectavg=getsectionsubjectaverage($schoolid,$classid,$nextsectionid,$examid,$subjectid,$newsubjectid);
$highchartexamnamearr[]="'$examname'";//($examportion)
$highchartsectionsubjectavgarr[]=$sectionsubjectavg;
$sectionavg=getsectionsliptestaverage($schoolid,$classid,$sectionid,$subjectid,$newsubjectid,$sliptestid);
$nextsectionavg=getsectionsliptestaverage($schoolid,$classid,$nextsectionid,$subjectid,$newsubjectid,$sliptestid);
if($sectionavg!=0)
{
$portioncount++;
$sqlst1="select * from sliptest where SchoolId='$schoolid' and ClassId='$classid' and SectionId='$sectionid' and SlipTestId='$sliptestid'";
$resultst1=mysql_query($sqlst1) or die("error sliptest: ". mysql_error());
while($rowst1=mysql_fetch_array($resultst1))
{
$finalportion="";
$isactivity=$rowst1['IsActivity'];
$sliptestname=$rowst1['SlipTestName'];
$portionidarr=explode('#',$rowst1['Portion']);
for($i=0;$i<count($portionidarr);$i++)
{
$finalportion.="<li><b>".getportionname($schoolid,$portionidarr[$i])."</b>";
$finalportion.="</li>";
}
}
?>
<tr>
<td>
<a href='getstudentssliptestmark.php?sectionid=<?echo $sectionid?>&sliptestid=<? echo $sliptestid;?>' >
<? echo $finalportion;?>
</a>
</td>
<td>
<?
// fetch exam portion
$improveportionarr=array();
$sqlportion="select * from examportion where
SchoolId='$schoolid' and
ClassId='$classid' and
ExamId='$examid' and
SubjectId='$subjectid' and
NewSubjectId='$newsubjectid'";
$resultportion=mysql_query($sqlportion) or die("error: ". mysql_error());
while($rowportion=mysql_fetch_array($resultportion))
{
$portionid=$rowportion['PortionId'];
$portionavg=getsectionportionaverage($schoolid,$classid,$sectionid,$subjectid,$newsubjectid,$portionid);
if($normalisedsectionavg>$portionavg && $portionavg!=0)
{
$improveportionarr[]=getportionname($schoolid,$portionid);
}
}
$improvecount=count($improveportionarr);
if($improvecount>0)
{
if($whereimproveflag==0)
{
$whereimproveflag=1;
?>
<div class=" typeahead"><h1>Chapters to be concentrated</h1></div>
<?
}
?>
<div class="list">
<div class="subject1">
