jazal

Thanks for your support, I will try and work to get the database right.

The initial image i posted was to ask if i can get rank for subject in each term and overall rank in each term as it was display in the image like position in each subject and class position. Because i want each student should know its rank in each subject so they can know the subject they outsmart their colleague and also know the best student in each class overall in every term.

every class have project and assignment every term and they are consistent, The highest score for ca1, ca2, project and assignment in each subject is 10 . That table looks like this below +-----------+---------------+-----+-----+------------+---------+------+-------+ | studentid | subject | CA1 | CA2 | Assignment | Project | Exam | total | +-----------+---------------+-----+-----+------------+---------+------+-------+ | 2393 | English Lang. | 10 | 10 | 10 | 10 | 60 | 100 | | 2393 | Mathematics | 8 | 9 | 6 | 9 | 34 | 66 | | 2393 | BST | 9 | 10 | 5 | 10 | 42 | 76 | | 936 | English Lang. | 8 | 10 | 9 | 7 | 49 | 83 | | 936 | Mathematics | 10 | 10 | 6 | 6 | 44 | 76 | | 936 | BST | 5 | 5 | 4 | 9 | 17 | 40 | | 3391 | English Lang. | 8 | 10 | 9 | 3 | 50 | 69 | | 3391 | Mathematics | 8 | 10 | 1 | 9 | 49 | 77 | | 3391 | BST | 8 | 10 | 3 | 1 | 54 | 76 | +-----------+---------------+-----+-----+------------+---------+------+-------+

i used his data structure the come with script that you said we have rebuild it so it can work properly. Overall score, Grade, Teacher Remark, total marks, percentage and result was done on the php script. i tired to derived rank for each subject and overall but i cant get it right. Thats why i want rebuild it from scratch. Any Help on that. Is it possible to have everything on database that what i just need to do is just query it out Thanks for your assistance

like this below

that was a sample of what i want to do. What i am tryin to do is that ca1, ca2, assignment and project are assignment with 10 marks each and exam have 60 marks and everything in total will be 100 in each subject.

`OverallMark` int(4) DEFAULT NULL, i forgot to add overall mark, this is have all the score in a specific term and also can be used to derived rank for class position

how can i derive the rank for each subject and overall rank using average thanks for your support

DROP TABLE IF EXISTS `tblresult`; CREATE TABLE IF NOT EXISTS `tblresult` ( `id` int(11) NOT NULL AUTO_INCREMENT, `StudentId` int(5) DEFAULT NULL, `ClassId` int(5) DEFAULT NULL, `SubjectId` int(5) DEFAULT NULL, `test1` int(2) DEFAULT NULL, `test2` int(2) DEFAULT NULL, `assignment` int(2) DEFAULT NULL, `project` int(2) DEFAULT NULL, `exam` int(2) DEFAULT NULL, `totalmark` int(3) DEFAULT NULL, `subjectrank` int(2) DEFAULT NULL, `rank` int(2) DEFAULT NULL, `term` VARCHAR (10) DEFAULT NULL, `percent` floatval(3) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tblresult` -- INSERT INTO `tblresult` (`id`, `Status`, `StudentId`, `ClassId`, `SubjectId`, `exam`, `test`) VALUES (1, 1, 1, 2, 10, 10, 5, 9, 30, `first`), (2, 1, 1, 2, 2, 4, 8, 7, 30, `first`), (3, 1, 1, 2, 6, 3, 9, 5, 45, `first`), (4, 1, 1, 2, 5, 5, 5, 1, 30, `first`), (5, 1, 1, 2, 4, 10, 5, 3, 50, `first`); (1, 1, 1, 3, 10, 10, 5, 7, 30, `first`), (2, 1, 1, 3, 2, 10, 8, 9, 30, `first`), (3, 1, 1, 3, 6, 7, 9, 8, 25, `first`), (4, 1, 1, 3, 5, 8, 5, 10, 35, `first`), (5, 1, 1, 3, 7, 10, 5, 5, 55, `first`); i want to add test1, test2, assignment and project to give me total mark, then total mark of each subject id determine subject rank and percentage determine the position in class for each term

DROP TABLE IF EXISTS `tblresult`; CREATE TABLE IF NOT EXISTS `tblresult` ( `id` int(11) NOT NULL AUTO_INCREMENT, `StudentId` int(5) DEFAULT NULL, `ClassId` int(5) DEFAULT NULL, `SubjectId` int(5) DEFAULT NULL, `exam` int(2) DEFAULT NULL, `test` int(2) DEFAULT NULL, `finalmark` int(3) DEFAULT NULL, `rank` int(2) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tblresult` -- INSERT INTO `tblresult` (`id`, `Status`, `StudentId`, `ClassId`, `SubjectId`, `exam`, `test`) VALUES (1, 1, 1, 2, 50, 30), (2, 1, 1, 2, 20, 30), (3, 1, 1, 2, 10, 30), (4, 1, 1, 2, 15, 35), (5, 1, 1, 3, 40, 15); i want to add test and exam score for final mark result and also final mark decide rank

okay, thanks. will kindly do that

can we change all to 150? cos it work good on my live server

-- phpMyAdmin SQL Dump -- version 5.0.2 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1:3306 -- Generation Time: Jan 05, 2021 at 09:16 AM -- Server version: 5.7.31-log -- PHP Version: 7.4.9 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `api_app` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- DROP TABLE IF EXISTS `admin`; CREATE TABLE IF NOT EXISTS `admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fullname` varchar(1000) DEFAULT NULL, `role` varchar(1000) DEFAULT NULL, `email` varchar(255) NOT NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `user_token` varchar(255) NOT NULL, `date` datetime NOT NULL, `ip` varchar(255) NOT NULL, `mobile` varchar(255) DEFAULT NULL, `passport` varchar(1000) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- -- Dumping data for table `admin` -- INSERT INTO `admin` (`id`, `fullname`, `role`, `email`, `username`, `password`, `user_token`, `date`, `ip`, `mobile`, `passport`) VALUES (1, 'admin', 'admin', '[email protected]', 'admin', '21232f297a57a5a743894a0e4a801fc3', '', '2021-01-13 15:08:14', '', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `settings` -- DROP TABLE IF EXISTS `settings`; CREATE TABLE IF NOT EXISTS `settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(10000) DEFAULT NULL, `description` text, `logo` varchar(1000) DEFAULT NULL, `siteback` varchar(1000) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`id`, `title`, `description`, `logo`, `siteback`) VALUES (1, 'Resut', 'Result Management', 'p.png', 'maxfemcollege.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `students_data` -- DROP TABLE IF EXISTS `students_data`; CREATE TABLE IF NOT EXISTS `students_data` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` varchar(10000) NOT NULL, `uiid` mediumtext NOT NULL, `class` varchar(255) DEFAULT NULL, `status` varchar(10000) NOT NULL, `full_name` varchar(10000) NOT NULL, `email` varchar(1000) NOT NULL, `mobile` varchar(100) NOT NULL, `dob` varchar(10000) NOT NULL, `age` varchar(1000) NOT NULL, `sex` varchar(1000) NOT NULL, `address` varchar(10000) NOT NULL, `nationality` varchar(150) NOT NULL, `state` varchar(50) NOT NULL, `lga` varchar(50) NOT NULL, `home_town` varchar(100) NOT NULL, `religion` varchar(100) NOT NULL, `prev_school` varchar(100) NOT NULL, `prev_school_date_attended` varchar(100) NOT NULL, `prev_school_class_read` varchar(100) NOT NULL, `prev_school_reasonforleaving` varchar(100) NOT NULL, `father_full_name` varchar(100) NOT NULL, `father_address` varchar(100) NOT NULL, `father_occupation` varchar(100) NOT NULL, `father_office_address` varchar(100) NOT NULL, `father_email` varchar(100) NOT NULL, `father_mobile` varchar(100) NOT NULL, `mother_full_name` varchar(100) NOT NULL, `mother_address` varchar(100) NOT NULL, `mother_occupation` varchar(100) NOT NULL, `mother_office_address` varchar(100) NOT NULL, `mother_email` varchar(100) NOT NULL, `mother_mobile` varchar(100) NOT NULL, `passport` varchar(10000) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `smsto` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tblclasses` -- DROP TABLE IF EXISTS `tblclasses`; CREATE TABLE IF NOT EXISTS `tblclasses` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ClassName` varchar(80) DEFAULT NULL, `ClassNameNumeric` int(4) NOT NULL, `Section` varchar(10000) NOT NULL, `CreationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `price` int(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `person_name_and_idx` (`ClassName`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tbldepartments` -- DROP TABLE IF EXISTS `tbldepartments`; CREATE TABLE IF NOT EXISTS `tbldepartments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `DepartmentName` varchar(10000) DEFAULT NULL, `CreationDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `Updationdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `person_name_and_idx` (`DepartmentName`(3072)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `tblresult` -- DROP TABLE IF EXISTS `tblresult`; CREATE TABLE IF NOT EXISTS `tblresult` ( `id` int(11) NOT NULL AUTO_INCREMENT, `StudentId` int(11) DEFAULT NULL, `ClassId` int(11) DEFAULT NULL, `Status` varchar(1000) DEFAULT NULL, `SubjectId` int(11) DEFAULT NULL, `revision_` int(250) DEFAULT '0', `adminstatus` int(250) DEFAULT '0', `marks` int(11) DEFAULT NULL, `tmarks` varchar(1000) DEFAULT NULL, `PostingDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `UpdationDate` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `term` varchar(10000) DEFAULT NULL, `year` varchar(10000) DEFAULT NULL, `Department` varchar(10000) DEFAULT NULL, `daysschool` varchar(1000) DEFAULT NULL, `dayspresent` varchar(1000) DEFAULT NULL, `daysabsence` varchar(1000) DEFAULT NULL, `termbegin` varchar(1000) DEFAULT NULL, `termends` varchar(1000) DEFAULT NULL, `termnext` varchar(1000) DEFAULT NULL, PRIMARY KEY (`id`), KEY `result_StudentId_and_ClassId` (`StudentId`,`ClassId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tblstudents` -- DROP TABLE IF EXISTS `tblstudents`; CREATE TABLE IF NOT EXISTS `tblstudents` ( `StudentId` int(11) NOT NULL AUTO_INCREMENT, `StudentName` varchar(100) NOT NULL, `classtype` varchar(1000) DEFAULT NULL, `session` varchar(1000) DEFAULT NULL, `logo` varchar(10000) DEFAULT NULL, `RollId` varchar(100) NOT NULL, `StudentEmail` varchar(100) NOT NULL, `mobile` varchar(1000) DEFAULT NULL, `Gender` varchar(10) NOT NULL, `DOB` varchar(100) NOT NULL, `ClassId` varchar(1000) DEFAULT NULL, `user_token` varchar(1000) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `UpdationDate` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `Status` int(1) NOT NULL, `Departments` mediumtext, `password` varchar(1000) DEFAULT NULL, PRIMARY KEY (`StudentId`), KEY `person_StudentId_and_StudentName` (`StudentName`,`StudentId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tblsubjectcombination` -- DROP TABLE IF EXISTS `tblsubjectcombination`; CREATE TABLE IF NOT EXISTS `tblsubjectcombination` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ClassId` int(11) NOT NULL, `SubjectId` int(11) NOT NULL, `status` int(1) DEFAULT NULL, `CreationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Updationdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `person_name_and_idx` (`ClassId`,`SubjectId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tblsubjects` -- DROP TABLE IF EXISTS `tblsubjects`; CREATE TABLE IF NOT EXISTS `tblsubjects` ( `id` int(11) NOT NULL AUTO_INCREMENT, `SubjectName` varchar(100) NOT NULL, `SubjectCode` varchar(100) NOT NULL, `Creationdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `UpdationDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `person_name_and_idx` (`SubjectName`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `teacher` -- DROP TABLE IF EXISTS `teacher`; CREATE TABLE IF NOT EXISTS `teacher` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fullName` varchar(255) NOT NULL, `pic` varchar(10000) DEFAULT NULL, `email` varchar(255) NOT NULL, `classid` int(100) DEFAULT NULL, `mobileNo` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Thanks @Barand

i already said it that i was trying to work on someone work to make it better

i just unable to do that, hmmmmmmm

i knew i messed up. Thanks for the time

Array

One-to-one relationships

@Barand i am thinking of adding the test scores together so that i can save the total score to the database and also student grade into database so that it will be easy for student rank Kindly check this code <?php session_start(); error_reporting(0); include('includes/config.php'); if(strlen($_SESSION['alogin'])=="") { header("Location: index.php"); } else{ $admint = isset($_GET["term"]) && !empty($_GET["term"]) ? $_GET["term"] : $adminresult->term ; $admins = isset($_GET["session"]) && !empty($_GET["session"]) ? $_GET["session"] : $adminresult->session; $stid=intval($_GET['stid']); if(isset($_POST['submit'])) { $rowid=$_POST['id']; $marks=$_POST['marks']; $t1marks=$_POST['t1marks']; $t2marks=$_POST['t2marks']; $t3marks=$_POST['t3marks']; $t4marks=$_POST['t4marks']; $totalmark=$_POST['totalmark']; $percent=$_POST['percent']; $subjectrank=$_POST['subjectrank']; $rank=$_POST['rank']; $daysschool=$_POST['daysschool']; $dayspresent=$_POST['dayspresent']; $daysabsence=$_POST['daysabsence']; $termbegin=$_POST['termbegin']; $termends=$_POST['termends']; $termnext=$_POST['termnext']; $tcomment=$_POST['tcomment']; $term = $_POST["term"]; $status_ = $_POST["status_"]; $adminstatus = $_POST["adminstatus"]; $revised = $_POST["revision"]; //Calcualte revision $revision_ = (int)$revised + 1; // echo $revision_; // return; //Loop through data foreach($_POST['id'] as $count => $id){ $mrks=$marks[$count]; $t1mrks=$t1marks[$count]; $t2mrks=$t2marks[$count]; $t3mrks=$t3marks[$count]; $t4mrks=$t4marks[$count]; $iid=$rowid[$count]; for($i=0;$i<=$count;$i++) { //Query data $sql="update tblresult set marks=:mrks, Status = :status_, t1marks=:t1mrks,t2marks=:t2mrks,t3marks=:t3mrks,t4marks=:t4mrks, tcomment=:tcomment,totalmark=:totalmark,percent=:percent,subjectrank=:subjectrank,rank=:rank, daysschool=:daysschool, dayspresent=:dayspresent, daysabsence=:daysabsence, termbegin=:termbegin, termends=:termends, termnext=:termnext, adminstatus=:adminstatus, revision_=:revision_ where id=:iid and term = :term and year = :year"; $query = $dbh->prepare($sql); $query->bindParam(':mrks',$mrks,PDO::PARAM_STR); $query->bindParam(':t1mrks',$t1mrks,PDO::PARAM_STR); $query->bindParam(':t2mrks',$t2mrks,PDO::PARAM_STR); $query->bindParam(':t3mrks',$t3mrks,PDO::PARAM_STR); $query->bindParam(':t4mrks',$t4mrks,PDO::PARAM_STR); $query->bindParam(':daysschool',$daysschool,PDO::PARAM_STR); $query->bindParam(':dayspresent',$dayspresent,PDO::PARAM_STR); $query->bindParam(':daysabsence',$daysabsence,PDO::PARAM_STR); $query->bindParam(':termbegin',$termbegin,PDO::PARAM_STR); $query->bindParam(':termends',$termends,PDO::PARAM_STR); $query->bindParam(':termnext',$termnext,PDO::PARAM_STR); $query->bindParam(':iid',$iid,PDO::PARAM_STR); $query->bindParam(':status_',$status_,PDO::PARAM_STR); $query->bindParam(':adminstatus',$adminstatus,PDO::PARAM_STR); $query->bindParam(':revision_',$revision_,PDO::PARAM_STR); $query->bindParam(':term',$admint,PDO::PARAM_STR); $query->bindParam(':year',$admins,PDO::PARAM_STR); $query->bindParam(':tcomment',$tcomment,PDO::PARAM_STR); $query->bindParam(':totalmark',$totalmark,PDO::PARAM_STR); $query->bindParam(':percent',$percent,PDO::PARAM_STR); $query->bindParam(':subjectrank',$subjectrank,PDO::PARAM_STR); $query->bindParam(':rank',$rank,PDO::PARAM_STR); $query->execute(); //log message $msg="Result info updated successfully"; } } } ?> <?php include('includes/header.php');?> <!-- ========== TOP NAVBAR ========== --> <?php include('includes/topbar.php');?> <!-- ========== WRAPPER FOR BOTH SIDEBARS & MAIN CONTENT ========== --> <style> #selectator_studentid{ width: 100% !important; } </style> <div class="content-wrapper"> <div class="content-container"> <!-- ========== LEFT SIDEBAR ========== --> <?php include('includes/leftbar.php');?> <!-- /.left-sidebar --> <div class="main-page"> <div class="container-fluid"> <div class="row page-title-div"> <div class="col-md-6"> <h2 class="title">Edit Student Result Info</h2> </div> <!-- /.col-md-6 text-right --> </div> <!-- /.row --> <div class="row breadcrumb-div"> <div class="col-md-6"> <ul class="breadcrumb"> <li><a href="dashboard.php"><i class="fa fa-home"></i> Home</a></li> <li class="active">Edit result</li> </ul> </div> </div> <!-- /.row --> </div> <div class="container-fluid"> <div class="row"> <div class="col-md-12"> <div class="row"> <div class="col-lg-3 col-md-1 col-sm-12"> </div> <div class="col-lg-6 col-md-9 col-sm-12"> <div class="panel"> <!--<div class="panel-heading">--> <!-- <div class="panel-title">--> <!-- <h5>Update the Result info</h5>--> <!-- </div>--> <!--</div>--> <div class="panel-body"> <?php if($msg){?> <div class="alert alert-success left-icon-alert" role="alert"> <strong>Well done!</strong> <?php echo htmlentities($msg); ?> </div><?php } else if($error){?> <div class="alert alert-danger left-icon-alert" role="alert"> <strong>Oh snap!</strong> <?php echo htmlentities($error); ?> </div> <?php } ?> <form class="form-horizontal" method="post" action=""> <?php $ret = "SELECT tblstudents.StudentName,tblstudents.logo,tblclasses.ClassName from tblresult join tblstudents on tblresult.StudentId=tblresult.StudentId join tblsubjects on tblsubjects.id=tblresult.SubjectId join tblclasses on tblclasses.id=tblstudents.ClassId where tblstudents.StudentId=:stid and tblresult.term = '$admint' and tblresult.year = '$admins' limit 1"; $stmt = $dbh->prepare($ret); $stmt->bindParam(':stid',$stid,PDO::PARAM_STR); $stmt->execute(); $result=$stmt->fetchAll(PDO::FETCH_OBJ); $cnt=1; if($stmt->rowCount() > 0) { foreach($result as $row) { ?> <div class="form-group"> <div class="col-sm-12 col-10 text-center"> <a href="images/<?php echo htmlentities($row->logo); ?>" data-fancybox="images" data-caption="<?php echo htmlentities($row->StudentName);?>"> <img src="images/loading.gif" class="lazy" data-srcset="images/<?php echo htmlentities($row->logo); ?>" data-src="images/<?php echo htmlentities($row->logo); ?>" style="height: 128px; border-radius: 21px; box-shadow: 6px 8px 11px -9px;"> </a> <h3 style="margin: 0px; margin-top: 6px;"><?php echo htmlentities($row->StudentName);?></h3> <h4 style=" margin: 0px; margin-top: 4px; color: grey;"><?php echo htmlentities($row->ClassName)?>: <?php $depart = $_GET['stid']; $query = mysqli_query($con, "SELECT Department FROM tblresult WHERE StudentId='$depart' and term = '$admint' and year = '$admins' ") or die(); $resultde = mysqli_fetch_assoc($query); $dpid = $resultde["Department"]; $squery = mysqli_query($con, "SELECT * FROM tbldepartments WHERE id = '$dpid' "); $sqresult = mysqli_fetch_assoc($squery); echo htmlentities($sqresult['DepartmentName']); ?> Dpt.</h4> <h5 style=" margin: 0px; margin-top: 3px; color: #adadadad;"> SESSION: <?php $depart = $_GET['stid']; $query = mysqli_query($con, "SELECT * FROM tblresult WHERE StudentId='$depart' and term = '$admint' and year = '$admins' ") or die(); $resultde = mysqli_fetch_assoc($query); echo $resultde["year"]; ?></h5> </div> </div> <hr> <div class="form-group"> <label for="default" class="col-sm-2 control-label">Term</label> <div class="col-sm-10"> <?php $depart = $_GET['stid']; $query = mysqli_query($con, "SELECT * FROM tblresult WHERE StudentId='$depart' and term = '$admint' and year = '$admins' ") or die(); $resultde = mysqli_fetch_assoc($query); ?> <select name="term" class="form-control" readonly> <option value="<?php echo $resultde["term"]; ?>"><?php echo $resultde["term"]; ?></option> </select> </div> </div> <div class="form-group"> <label for="default" class="col-sm-2 control-label">No. of Days School Opened</label> <div class="col-sm-10"> <input type="text" name="daysschool" class="form-control" value="<?php echo htmlentities($resultde['daysschool']); ?>"> </div> </div> <div class="form-group"> <label for="default" class="col-sm-2 control-label">No. of Days Present</label> <div class="col-sm-10"> <input type="text" name="dayspresent" class="form-control" value="<?php echo htmlentities($resultde['dayspresent']); ?>"> </div> </div> <div class="form-group"> <label for="default" class="col-sm-2 control-label">No. of Days Absence</label> <div class="col-sm-10"> <input type="text" name="daysabsence" class="form-control" value="<?php echo htmlentities($resultde['daysabsence']); ?>"> </div> </div> <div class="form-group"> <label for="default" class="col-sm-2 control-label">Term Begins</label> <div class="col-sm-10"> <input type="text" name="termbegin" class="form-control" value="<?php echo htmlentities($resultde['termbegin']); ?>"> </div> </div> <div class="form-group"> <label for="default" class="col-sm-2 control-label">Term Ends</label> <div class="col-sm-10"> <input type="text" name="termends" class="form-control" value="<?php echo htmlentities($resultde['termends']); ?>"> </div> </div> <div class="form-group"> <label for="default" class="col-sm-2 control-label">Next Term Begins</label> <div class="col-sm-10"> <input type="text" name="termnext" class="form-control" value="<?php echo htmlentities($resultde['termnext']); ?>"> </div> </div> <div class="form-group"> <label for="default" class="col-sm-2 control-label">Teachers Status</label> <div class="col-sm-10"> <select name="status_" class="form-control" required> <option value="<?php echo ($resultde['Status'] == 0)? "0": "1"; ?>" selected> <?php echo ($resultde['Status'] == 0)? "Pending": "Review"; ?> </option> <option value="0">======</option> <option value="1">Review</option> <option value="0">Pending</option> </select> </div> </div> <!-- Revision --> <input type="hidden" name="revision" value="<?php echo $resultde['revision_']; ?>"> <!-- Revision --> <?php if (!isset($_SESSION["teacher"])) { ?> <div class="form-group"> <label for="default" class="col-sm-2 control-label bg-success">Admin Status</label> <div class="col-sm-10"> <select name="adminstatus" class="form-control bg-success text-white"> <option value="<?php echo $resultde['adminstatus']; ?>" selected> <?php echo ($resultde['adminstatus'] == 0)? "On Hold": "Live"; ?> </option> <option value="0">======</option> <option value="1">Live</option> <option value="0">On Hold</option> </select> </div> </div> <?php }else{ ?> <input type="hidden" name="adminstatus" value="0"> <p><b>Enter Teachers Comment:</b></p> <input type="text" name="tcomment" class="form-control" id="comment" value="<?php echo htmlentities($resultde['tcomment'])?>" placeholder="Enter Teachers Comment" autocomplete="on" min="0" max="1000"> <?php } ?> <?php } }?> <hr> <?php $sql = "SELECT distinct tblstudents.StudentName,tblstudents.StudentId,tblclasses.ClassName,tblclasses.Section,tblsubjects.SubjectName,tblresult.marks,tblresult.t1marks,tblresult.t2marks,tblresult.t3marks,tblresult.t4marks,tblresult.totalmark,tblresult.rank,tblresult.subjectrank,tblresult.percent,tblresult.id as resultid from tblresult join tblstudents on tblstudents.StudentId=tblresult.StudentId join tblsubjects on tblsubjects.id=tblresult.SubjectId join tblclasses on tblclasses.id=tblstudents.ClassId where tblstudents.StudentId=:stid and tblresult.term = '$admint' and tblresult.year = '$admins'"; $query = $dbh->prepare($sql); $query->bindParam(':stid',$stid,PDO::PARAM_STR); $query->execute(); $results=$query->fetchAll(PDO::FETCH_OBJ); $cnt=1; if($query->rowCount() > 0) { foreach($results as $result) { ?> <div class="form-group"> <label for="default" class="col-sm-2 control-label"><?php echo htmlentities($result->SubjectName)?></label> <div class="col-sm-10"> <input type="hidden" name="id[]" value="<?php echo htmlentities($result->resultid)?>"> <p><b>Result for Exam:</b></p> <input type="number" name="marks[]" class="form-control" id="marks" value="<?php echo htmlentities($result->marks)?>" placeholder="Enter marks out of 60" autocomplete="off" min="0" max="60"> <p><b>Result for 1st Test:</b></p> <input type="number" name="t1marks[]" class="form-control" id="marks" value="<?php echo htmlentities($result->t1marks)?>" placeholder="Enter marks out of 10" autocomplete="off" min="0" max="10"> <p><b>Result for 2nd Test:</b></p> <input type="number" name="t2marks[]" class="form-control" id="marks" value="<?php echo htmlentities($result->t2marks)?>" placeholder="Enter marks out of 10" autocomplete="off" min="0" max="10"> <p><b>Result for Assignment:</b></p> <input type="number" name="t3marks[]" class="form-control" id="marks" value="<?php echo htmlentities($result->t3marks)?>" placeholder="Enter marks out of 10" autocomplete="off" min="0" max="10"> <p><b>Result for Project:</b></p> <input type="number" name="t4marks[]" class="form-control" id="marks" value="<?php echo htmlentities($result->t4marks)?>" placeholder="Enter marks out of 10" autocomplete="off" min="0" max="10"> </div> </div> <?php }} ?> <div class="form-group"> <div class="col-sm-offset-2 col-sm-10"> <button type="submit" name="submit" class="btn btn-primary">Update</button> <a href="manage-results.php" class="btn btn-primary" style="float: right;background: black;color: white;"> Manage Results </a> </div> </div> </form> </div> </div> </div> <div class="col-lg-3 col-md-1 col-sm-12"> </div> </div> </div> <!-- /.col-md-12 --> </div> </div> </div> <!-- /.content-container --> </div> <!-- /.content-wrapper --> </div> <?php include 'includes/credit.php'; ?> <!-- /.main-wrapper --> <!--<script src="js/jquery/jquery-2.2.4.min.js"></script>--> <script src="js/bootstrap/bootstrap.min.js"></script> <script src="js/pace/pace.min.js"></script> <script src="js/lobipanel/lobipanel.min.js"></script> <script src="js/iscroll/iscroll.js"></script> <script src="js/prism/prism.js"></script> <script src="js/select2/select2.min.js"></script> <script src="js/main.js"></script> <script> $(function($) { $(".js-states").select2(); $(".js-states-limit").select2({ maximumSelectionLength: 2 }); $(".js-states-hide").select2({ minimumResultsForSearch: Infinity }); }); </script> </body> </html> <?PHP } ?>

Can you show me how to use join on a single query and i dont know he used it. its not mine, just trying to work on it. echo $sqresult['DepartmentName'] == " " ? " " : " ";

Here is the code to view result but i noticed that everything was done here, i want my sql to add result of each subject of each student then save it in total colomn and also average and grade with total percent in each term <?php session_start(); error_reporting(0); include('includes/config.php'); ?> <?php include('includes/header.php'); $admint = $adminresult->term; $admins = $adminresult->session; ?> <style type="text/css"> .content-wrapper { margin: 0 auto; max-width: 1336px; min-width: 1336px; } @media print { .content-wrapper .yes_print { margin: 0 auto; max-width: 1100px; min-width: 1100px; } .print_p { padding-top: 0px !important; } .content-wrapper { margin: 0 auto; max-width: 100%; min-width: 100%; } } </style> <div class="content-wrapper"> <div class="content-container"> <!-- /.left-sidebar --> <div class="main-page"> <div class="container-fluid"> <div class="row page-title-div" style="background: transparent;"> <?php $stmt = $dbh->query("SELECT * FROM settings"); $rowprint = $stmt->fetch(PDO::FETCH_OBJ); ?> <?php // code Student Data $rollid=$_POST['studentid']; $classid=$_POST['class']; $_SESSION['rollid']=$rollid; $_SESSION['classid']=$classid; $qery = "SELECT tblstudents.StudentName,tblstudents.logo,tblstudents.Departments,tblstudents.RollId,tblstudents.RegDate,tblstudents.StudentId,tblstudents.Status,tblclasses.ClassName,tblclasses.Section from tblstudents join tblclasses on tblclasses.id=tblstudents.ClassId where tblstudents.RollId=:rollid and tblstudents.ClassId=:classid "; $stmt = $dbh->prepare($qery); $stmt->bindParam(':rollid',$rollid,PDO::PARAM_STR); $stmt->bindParam(':classid',$classid,PDO::PARAM_STR); $stmt->execute(); $resultss=$stmt->fetchAll(PDO::FETCH_OBJ); $cnt=1; if($stmt->rowCount() > 0) { foreach($resultss as $row) { ?> <div class="printindis" style="width: 100%;"> <img src="images/<?php echo htmlentities($rowprint->logo); ?>" style="height: 124px;margin-left: 12%;"> <div style="float: right;margin-right: 16%;text-align: center;"> <div style="float: left;"> <h1 style="text-transform: uppercase;margin: 0px;font-size: 38px;margin-bottom: 7px;font-family: Arial Black;"> <?php echo htmlentities($rowprint->title); ?></h1> <p style="text-transform: uppercase;font-weight: bold;background: black;color: white;padding: 5px;text-align: left;margin-bottom: 1px;"> <b style="margin-left: 31px;">Motto:</b> <span style="margin-left:37px; "><?php echo htmlentities($rowprint->description); ?></span> </p> <p style="margin:0px;padding: 0px;"> <?php echo $rowprint->address1 ?> </p> <p style="margin:0px;padding: 0px;"> <?php echo $rowprint->address2 ?> </p> </div> <div style="float: left;background: url('images/<?php echo htmlentities($row->logo); ?>');height: 121px;width: 144px;background-position: center top;background-size: cover;background-repeat: no-repeat;margin-left: 39px;border: 2px solid #d3d3d3;"> </div> </div> </div> <!-- For Printing --> <div class="yes_print"> <div class="printing" style="width: 100%;margin-left: auto;margin-right: auto;"> <div style="margin-left: 207px;text-align: center;"> <div style="float: left;margin-left: -22%;"> <img src="images/<?php echo htmlentities($rowprint->logo); ?>" style="height: 110px;margin-left: 0%;"> </div> <div style=" float: left;margin-left: -5%;"> <h1 style="text-transform: uppercase;margin: 0px;font-size: 30px;margin-bottom: 7px;font-family: Arial Black;"> <?php echo htmlentities($rowprint->title); ?></h1> <p style="text-transform: uppercase;font-weight: bold;background: black;color: white;padding: 5px;text-align: left;margin-bottom: 1px;"> <b style="margin-left: 31px;">Motto:</b> <span style="margin-left:37px; "><?php echo htmlentities($rowprint->description); ?></span> </p> <p style="margin:0px;padding: 0px;"> <?php echo $rowprint->address1 ?> </p> <p style="margin:0px;padding: 0px;"> <?php echo $rowprint->address2 ?> </p> </div> <div style="float: left;"> <img src="images/<?php echo htmlentities($row->logo); ?>" style="height: 113px; border: 2px solid #d3d3d3; object-fit: cover; width: 133px; object-position: center top; margin-left: 5px;"> </div> </div> <?php } ?> </div> </div> <!-- /.row --> <!-- /.row --> </div> <!-- /.container-fluid --> <section class="section print_p"> <div class="container-fluid"> <div class="row"> <div class="col-md-8 col-md-offset-2"> <div class="panel print_p"> <div class="panel-heading print_p"> <div class="panel-title print_p"> <?php // code Student Data $rollid=$_POST['studentid']; $classid=$_POST['class']; $_SESSION['rollid']=$rollid; $_SESSION['classid']=$classid; $qery = "SELECT tblstudents.StudentName,tblstudents.Gender,tblstudents.DOB,tblstudents.Departments,tblstudents.RollId,tblstudents.RegDate,tblstudents.StudentId,tblstudents.Status,tblclasses.ClassName,tblclasses.Section from tblstudents join tblclasses on tblclasses.id=tblstudents.ClassId where tblstudents.RollId=:rollid and tblstudents.ClassId=:classid "; $stmt = $dbh->prepare($qery); $stmt->bindParam(':rollid',$rollid,PDO::PARAM_STR); $stmt->bindParam(':classid',$classid,PDO::PARAM_STR); $stmt->execute(); $resultss=$stmt->fetchAll(PDO::FETCH_OBJ); $cnt=1; if($stmt->rowCount() > 0) { ?> <h2 style="text-align: center;margin-bottom: 5px;font-family: calibri;"> Assessment Report <br> <?php $dpid = $row->Departments; $squery = mysqli_query($con, "SELECT * FROM tbldepartments WHERE id = '$dpid' "); $sqresult = mysqli_fetch_assoc($squery); echo $sqresult['DepartmentName'] == " " ? " " : " "; ?> </h2> <?php foreach($resultss as $row) { ?> <div class="firsttable" style="float: left;width: 35%;"> <table class="table table-hover table-bordered" style="width: 100%;text-align: left;"> <thead> <tr> <th scope="row" colspan="3" class="tst" style="padding: 10px;text-transform: uppercase;"> <h3>Student Personal Data</h3> </th> </tr> </thead> <tbody> <tr> <td scope="row" colspan="2" style="font-weight: bold;">Name <em>(Surname First)</em> </td> <td id="studentnameid" style="text-align: center;text-transform: uppercase;"> <?php echo htmlentities($row->StudentName);?></td> </tr> <tr> <td scope="row" colspan="2" style="font-weight: bold;">Date of Birth</td> <td style="text-align: center;text-transform: uppercase;"> <?php echo htmlentities(date("F j, Y", strtotime($row->DOB)));?> </td> </tr> <tr> <td scope="row" colspan="2" style="font-weight: bold;">Sex </td> <td style="text-align: center;text-transform: uppercase;"> <?php echo htmlentities($row->Gender);?></td> </tr> <tr> <td scope="row" colspan="2" style="font-weight: bold;">Class </td> <td id="classname" style="text-align: center;text-transform: uppercase;"> <?php echo htmlentities($row->ClassName);?></td> </tr> <tr> <td scope="row" colspan="2" style="font-weight: bold;"> Department </td> <td style="text-align: center;text-transform: uppercase;"><?php $dpid = $row->Departments; $squery = mysqli_query($con, "SELECT * FROM tbldepartments WHERE id = '$dpid' "); $sqresult = mysqli_fetch_assoc($squery); echo htmlentities($sqresult['DepartmentName']); ?></td> </tr> <tr> <td scope="row" colspan="2" style="font-weight: bold;"> Student ID </td> <td style="text-align: center;text-transform: lowercase;"> <code><?php echo htmlentities($row->RollId);?></code> </td> </tr> </tbody> </table> </div> <div class="secondtable" style="float: right;width: 64%;"> <table class="table table-hover table-bordered" style="width: 100%;text-align: center;"> <thead> <tr> <th scope="row" colspan="3" class="tst" style="padding: 10px;text-transform: uppercase;"> <h3>attendance</h3> </th> </tr> </thead> <tbody> <tr> <td scope="row" colspan="1" style="text-align: center;font-weight: bold;">No. of Days School Opened</td> <td scope="row" colspan="1" style="text-align: center;font-weight: bold;">No. of Days Present</td> <td scope="row" colspan="1" style="text-align: center;font-weight: bold;">No. of Days Absent</td> </tr> <tr> <?php $moreid = $row->StudentId; $stmt = $dbh->query("SELECT * FROM tblresult WHERE StudentId = '$moreid' and term = '$admint' and year = '$admins'"); $moredata = $stmt->fetch(PDO::FETCH_OBJ); ?> <td><?php echo htmlentities($moredata->daysschool); ?></td> <td><?php echo htmlentities($moredata->dayspresent); ?></td> <td><?php echo htmlentities($moredata->daysabsence); ?></td> </tr> </tbody> </table> <table class="table table-hover table-bordered" style="width: 100%;text-align: center;"> <thead> <tr> <th scope="row" colspan="3" class="tst" style="padding: 10px;text-transform: uppercase;"> <h3>terminal duration</h3> </th> </tr> </thead> <tbody> <tr> <td scope="row" colspan="1" style="text-align: center;font-weight: bold;">Term Begins</td> <td scope="row" colspan="1" style="text-align: center;font-weight: bold;">Term Ends </td> <td scope="row" colspan="1" style="text-align: center;font-weight: bold;">Next Term Begins</td> </tr> <tr> <td><?php echo htmlentities($moredata->termbegin); ?></td> <td><?php echo htmlentities($moredata->termends); ?></td> <td><?php echo htmlentities($moredata->termnext); ?></td> </tr> </tbody> </table> </div> <?php $termid = $row->StudentId; $query = mysqli_query($con, "SELECT term FROM tblresult WHERE StudentId='$termid' and term = '$admint' and year = '$admins'") or die(); $resultterm = mysqli_fetch_assoc($query); ?> <?php } } ?> </div> <style type="text/css"> table { text-align: center; } th { text-align: center; } .tst { background: lightgrey; } </style> <div class="panel-body p-20"> <table class="table table-hover table-bordered" style="text-align: center;"> <div style="padding: 10px;text-align: center;background:lightgrey;text-transform: uppercase;clear: both;" class="print_p"> <h3>Academic Performance</h3> </div> <thead> <tr> <th></th> <th>1st Test</th> <th>2nd Test</th> <th>Assignment</th> <th>Project</th> <th>Exam Score</th> <th>Overall Score</th> <th>Grade</th> <th>Teacher's Remark</th> </tr> <tr> <th class="tst">Max Obt. Mark</th> <th class="tst">10</th> <th class="tst">10</th> <th class="tst">10</th> <th class="tst">10</th> <th class="tst">60</th> <th class="tst">100</th> <th class="tst"></th> <th class="tst"></th> </tr> </thead> <tbody> <?php // Code for result $query ="select t.StudentName,t.RollId,t.ClassId,t.term,t.year,t.marks,t.t1marks,t.t2marks,t.t3marks,t.t4marks,SubjectId,tblsubjects.SubjectName from (select sts.StudentName,sts.RollId,sts.ClassId,tr.term,tr.year,tr.marks,tr.t1marks,tr.t2marks,tr.t3marks,tr.t4marks,SubjectId from tblstudents as sts join tblresult as tr on tr.StudentId=sts.StudentId) as t join tblsubjects on tblsubjects.id=t.SubjectId where t.RollId=:rollid and t.ClassId=:classid and t.term = :term and t.year = :year "; // and t.term = :term and t.year = :year // $bettersql = ""; $query= $dbh -> prepare($query); $query->bindParam(':rollid',$rollid,PDO::PARAM_STR); $query->bindParam(':classid',$classid,PDO::PARAM_STR); $query->bindParam(':term',$admint,PDO::PARAM_STR); //I stoped here $query->bindParam(':year',$admins,PDO::PARAM_STR); $query-> execute(); $results = $query -> fetchAll(PDO::FETCH_OBJ); $cnt=1; if($countrow=$query->rowCount()>0) { foreach($results as $result){ ?> <?php if($result->marks+$result->t1marks+$result->t2marks+$result->t3marks+$result->t4marks > 1){ ?> <tr> <td><?php echo htmlentities($result->SubjectName);?></td> <td><?php echo htmlentities($result->t1marks < 1 ? "--" : $result->t1marks);?> <td><?php echo htmlentities($result->t2marks < 1 ? "--" : $result->t2marks);?> <td><?php echo htmlentities($result->t3marks < 1 ? "--" : $result->t3marks);?> <td><?php echo htmlentities($result->t4marks < 1 ? "--" : $result->t4marks);?> </td> <td><?php echo htmlentities($result->marks < 1 ? "--" : $result->marks);?> </td> <td><?php echo htmlentities($totalmarks=$result->marks + $result->t1marks + $result->t2marks + $result->t3marks + $result->t4marks < 1 ? "--" :$result->marks + $result->t1marks + $result->t2marks + $result->t3marks + $result->t4marks );?> </td> <td> <?php if ($totalmarks >= 80 ) { echo "A"; } elseif ($totalmarks >= 79 ) { echo "B"; } elseif ($totalmarks >= 69) { echo "C"; } elseif ($totalmarks >= 49) { echo "D"; } elseif ($totalmarks >= 45) { echo "E"; } elseif ($totalmarks < 45) { echo $result->marks+$result->tmarks < 1 ? "--" : "F"; } ?></td> <td> <?php if ($totalmarks >= 80) { echo "Excellent"; } elseif ($totalmarks >= 70) { echo "Very Good"; } elseif ($totalmarks >= 50) { echo "Good"; } elseif ($totalmarks >= 40) { echo "Fair"; } if ($totalmarks < 45) { echo $result->marks + $result->t1marks + $result->t2marks + $result->t3marks + $result->t4marks < 1 ? "--" : "Fail"; } ?></td> </tr> <?php $totlcount+=$totalmarks; $cnt++; } } ?> <tr> <th scope="row" colspan="1" class="tst">Num Of Sub</th> <th scope="row" colspan="2" class="tst">Total Marks</th> <th scope="row" colspan="1" class="tst">Percentage</th> <tr> <th scope="row" colspan="1"><?php $nud = $cnt-1; echo $nud; ?> </th> <th scope="row" colspan="2"><b><?php echo htmlentities($totlcount); ?></b> </th> <th scope="row" colspan="1"> </b><?php $nuc = $cnt-1; $num = $totlcount/$nuc; $totalnum = floatval($num); echo htmlentities($totalnum); ?> %</b></td> </tr> <tr> <th scope="row" colspan="1" class="tst">Result</th> <td><?php if ($num >= 45) { echo htmlentities ("Pass"); } elseif ($num < 45) { echo "Fail"; }?> </td> </tr> <tr> <th scope="row" colspan="1" class="tst">Teacher's Comment</th> <td scope="row" colspan="8" style="font-weight: bold;"> <?php echo htmlentities($moredata->tcomment);?> </td> </tr> <tr> <th scope="row" colspan="3">Print Result</th> <td></td> <th scope="row" colspan="3" onclick="window.print();" style="cursor: pointer;background: lightgrey;"><i class="fa fa-print"></i> Print Result</th> </tr> <?php } else { ?> <div class="alert alert-warning left-icon-alert" role="alert"> <strong>Notice!</strong> Your result not declare yet <?php } ?> </div> <?php } else{ ?> <div class="alert alert-danger left-icon-alert" role="alert"> <strong>Oh snap!</strong> <?php echo htmlentities("Wrong Student ID or Class"); echo "<a href='find-result.php' class='btn btn-primary' style='float: right;background: black;color: white;'>Check again</a>"; } ?> </div> </tbody> </table> </div> </div> <!-- /.panel --> </div> <!-- /.col-md-6 --> <div class="form-group"> <div class="col-sm-6"> <a href="manage-results.php">Back to Result</a> </div> </div> </div> <!-- /.row --> </div> <!-- /.container-fluid --> </div> </section> <!-- /.section --> </div> <!-- /.main-page --> </div> <!-- /.content-container --> </div> <!-- /.content-wrapper --> </div> <!-- /.main-wrapper --> <?php include 'includes/credit.php'; ?> <!-- ========== COMMON JS FILES ========== --> <script src="js/bootstrap/bootstrap.min.js"></script> <script src="js/pace/pace.min.js"></script> <script src="js/lobipanel/lobipanel.min.js"></script> <script src="js/iscroll/iscroll.js"></script> <!-- ========== PAGE JS FILES ========== --> <script src="js/prism/prism.js"></script> <!-- ========== THEME JS ========== --> <script src="js/main.js"></script> <script> $(function($) { var name = $("#studentnameid").text(); var data = name.replace(/\s{2,}/g, ' '); var className = $("#classname").text(); var classsub = className.replace(/\s{2,}/g, ' '); document.title = data + " :: " + classsub; }); </script> <!-- ========== ADD custom.js FILE BELOW WITH YOUR CHANGES ========== --> </body> </html>

@Baranda friend share a school result management script with me, but i am trying to add student subject rank to the view result and overall rank in class to it.

@ginerjmi want my database to show the student that come first in each subjects and overall in class

I want create subject Postion and overall class position like image below, I need assistance. Where will I start from?