STUDENT LIST
-
0)
{
while($c_row = mysqli_fetch_array($c_result))
{
$course_id = $c_row['id'];
$course_name = $c_row['course_name'];
$sl_sql="SELECT sl.id,sl.course_id,cm.course_name,sl.academic_year_id,ay.academic_year,sl.student_list_name,sl.student_list_path FROM student_lists as sl left outer join course_master as cm on sl.course_id=cm.id and cm.status='Y' left outer join academic_year_master as ay on sl.academic_year_id=ay.id and ay.status='Y' where sl.status='Y' and sl.course_id='".$course_id."' and sl.academic_year_id='".$_GET['academic_year_id']."' order by sl.id desc limit 0,1";
$sl_result = mysqli_query($db, $sl_sql);
if(mysqli_num_rows($sl_result) > 0)
{
while($sl_row = mysqli_fetch_array($sl_result))
{
$student_list_path = $sl_row['student_list_path'];
echo'
- '.$course_name.' STUDENT LIST '; } } } } ?>
STUDENT LIST YEAR
-
0)
{
while($ay_row = mysqli_fetch_array($ay_result))
{
$academic_year_id = $ay_row['id'];
$academic_year = $ay_row['academic_year'];
echo'
- '.$academic_year.' '; } } ?>
