$sqlst="select * from sliptest where
SchoolId='$schoolid' and
SliptestId='$sliptestid'";
$resultst=mysql_query($sqlst) or die("error: ". mysql_error());
while($rowst=mysql_fetch_array($resultst))
{
$maxmark=$rowst['MaximumMark'];
$count++;
$markavg+=($mark/$maxmark);
}
}
$temp=round(($markavg*100)/$count);
?>
<tr>
<td ><a href='getstudentmarkportionwise.php?studentid=<? echo $studentid?>&subjectidmixed=<? echo $subjectidmixed;?>'>
<? echo $studentname;?>
</a>
</td>
<td class='<? echo gettdcolor($temp)?>'>
<? echo $temp;?>
</td>
</tr>
<?
}
?>
</table>
</div>
</div>
</body>
?>
</td>
<td>
<? echo "$date";?>
</a>
</td>
<td class='<? echo gettdcolor($sectionavg)?>'>
<? echo $sectionavg;?>
</td>
<?
if($nextsectionid>0)
{
?>
<td class='<? echo gettdcolor($nextsectionavg)?>'>
<?
if($nextsectionavg==0)
{
echo "-";
}
else
{
echo $nextsectionavg;
}
?>
</td>
<?
}
?>
</tr>
$sqlportion="select * from portion where SchoolId='$schoolid' and ClassId='$classid' and SubjectId='$subjectid' and NewSubjectId='$newsubjectid'";
$resultportion=mysql_query($sqlportion) or die("error: ". mysql_error());
while($rowportion=mysql_fetch_array($resultportion))
{
$portionid=$rowportion['PortionId'];
$portionname=$rowportion['Portion'];
$markavg=getstudentportionaverage($schoolid,$classid,$sectionid,$subjectid,$newsubjectid,$studentid,$portionid);
if($markavg!=0)
{
?>
<tr>
<td>
<? echo $portionname;?>
</td>
<td class='<? echo gettdcolor($markavg)?> center'>
<? echo $markavg;?>
</td>
</tr>
<?
$portioncount++;
$highchartportionarr[]="'".shortenstring($portionname,15)."'";
$highchartmarkarr[]="{y: $markavg, color: '".getgraphcolor($markavg)."'}";
}
}
$highchartportion=implode(',',$highchartportionarr);
$highchartmark=implode(',',$highchartmarkarr);
