$examcount=mysql_num_rows($resultexam);
$exammean=0;
while($rowexam=mysql_fetch_array($resultexam))
{
$examid=$rowexam['ExamId'];
$subjectids=$rowexam['SubjectIDs'];
$subjectidarr=explode(',',$subjectids);
$subjectmean=0;
$subjectcount=count($subjectidarr);
for($i=0;$i<count($subjectidarr);$i++)
{
$subjectid=$subjectidarr[$i];
if(!in_array($subjectid,$addedsubjectarr))
{
$addedsubjectarr[]=$subjectid;
$subjectname=getsubjectname($subjectid);
$option.="<option value='$subjectid'>$subjectname</option>";
}
}
}
?>
<div id='portionheading'>
<input type='hidden' name='sortoption' id='sortoption' value='<? echo $sortoption;?>' />
Select Subject:
<select name='subjectid' id='subjectid' onchange='getallstudentoverallsubjectmark()'>
<? echo "$option";?>
</select>
</div>
<div class="span5 areaselect">
Student Name
</th>
<?
for($i=0;$i<count($subjectidarr);$i++)
{
$subjectid=$subjectidarr[$i];
$sqlmax="select * from subjectexams where SchoolId='$schoolid' and ClassId='$classid' and ExamId='$examid' and SubjectId='$subjectid'";
$resultmax=mysql_query($sqlmax) or die("error: ". mysql_error());
while($rowmax=mysql_fetch_array($resultmax))
{
$maxmark=$rowmax['MaximumMark'];
$maxmarkarr[$i]=$maxmark;
$totalmaxmark+=$maxmark;
}
echo "<th>";
echo getsubjectname($subjectid)."<br/>(/$maxmark)";
echo "</th>";
}
?>
<?
if($gradesystem!=1)
{
?>
<th>
<? echo "Total<br/>(/$totalmaxmark)"; ?>
</th>
<th>
<? echo "Section Rank<br/>(/$studentcount)"; ?>
</th>
<th>
$distinctsubjectidarr=array();
$colorcount=0;
?>
Select Subject:<select name='subjectid' id='subjectid' onchange='getexamanalysis()'>
<option value='0'>All Subjects</option>
<?
$sqlexam="select * from exams where SchoolId='$schoolid' and ClassId='$classid' and MarkUploaded='1'";
$resultexam=mysql_query($sqlexam) or die("error:". mysql_error());
$examcount=mysql_num_rows($resultexam);
while($rowexam=mysql_fetch_array($resultexam))
{
$examid=$rowexam['ExamId'];
$examname=$rowexam['ExamName'];
$subjectids=$rowexam['SubjectIDs'];
$subjectidarr=explode(',',$subjectids);
for($i=0;$i<count($subjectidarr);$i++)
{
$subjectid=$subjectidarr[$i];
if(!in_array($subjectid,$distinctsubjectidarr))
{
$entered=1;
$distinctsubjectidarr[]=$subjectid;
echo "<option value='$subjectid'>".getsubjectname($subjectid)."</option>";
}
}
}
?>
</select>
function gethomework($schoolid,$classid,$sectionid,$homeworkdate)
{
$flag=0;
$j=1;
$sql="select * from homeworkmessage where SchoolId='$schoolid' and ClassId='$classid' and SectionId='$sectionid' and HomeworkDate='$homeworkdate' order by DateTimeRecordInserted desc";
$result = mysql_query($sql) or die('Query failed1: ' . mysql_error());
while($row=mysql_fetch_array($result))
{
$flag=1;
$homeworkarr=explode('#',$row['Homework']);
$subjectidarr=explode(',',$row['SubjectIDs']);
$homework="";
for($j=0;$j<count($subjectidarr);$j++)
{
$subjectid=$subjectidarr[$j];
if($subjectid==0)
{
$subjectname="EXTRA";
}
else
{
$subjectname=strtoupper(getsubjectname($subjectid));
}
if($homeworkarr[$j]!="")
{
$homework.="<tr><td>$subjectname</td><td>$homeworkarr[$j]</td></tr>";
}
}
}
if($flag==0)
{
$homework="<tr><td colspan='2'>Homework has not been uploaded.</td></tr>";
}
$date=$homeworkdate;
$datearr=explode('-',$date);
$monthname=getmonth($datearr[1]);
$day=$datearr[2];
?>
<table class="table table-striped">
<tr>
<th align='left'>
<?
echo "$day $monthname";
?>
</th>
<th>
</th>
</tr>
<?
echo $homework;
?>
</table>
<?
}
