$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);