vankaid:

Most times programming challenges are usually solved with an idea that is completely different from the perspective you are approaching it.

I do not know the full details of the CA and exam score tables so I cant help much.

How ever, have you thought about summing CAs and exam scores separately and saving each total in a variable which you can also add together.

i dont understand your situation properly so my advise might not make any sense.

Please provide more details.

Attached are screenshot of the database... each row contains score of each student on different subjects.. There are records of different student in the class.. I want to sum each Ca score and exam for each subject for each student, and compare the total score of each student on a subject, for all student, and get the highest score in the class, for that subject..

Good Morning nairalanders. Please i have an issue i would really like Php programmers to help me in resolving. Am working on a school management system at the office.. After completing the project, it turns out that i ought to create a space on the result sheet for Highest Mark, and Lowest Mark and Grade. I have the exam result and CA on different tables in the database. I want to join this tables, add up each student score (over 100) and compare which of the student scored highest and lowest on each subject.. Please i will really appreciate if you guys can guide me through, using Php. I already tried while loop, but ran into some issues especially when trying to compare the results and display the highest score. it keeps bringing out list of numbers. Below is a sample of the experiment am trying to work out from. I doubt if its result is reasonable though as i have altered it beyond recognition out of frustration.. Thanks guys..


<?php
require_once("database.php";
$usid="uj@k.c";

$select=mysqli_query($mysqli,"SELECT * FROM `exam_result` " or die(mysqli_error($mysqli));

if($select==true)
{
while($array=mysqli_fetch_array($select))
{
$total2=$array['English'] + $array['maths'];

}
$select2= mysqli_query($mysqli,"SELECT * FROM `ca_result` " or die(mysqli_error($mysqli));

if($select2 ==true)
{
while($array2=mysqli_fetch_array($select2))
{

$all=array_shift(array_slice($array2, 0, 1));
echo $total=$all['sn'];

//$value2=$value['$total'];


//break;

//echo $total2."<br>";


//$value=current($array2);
//echo $value."<br>";


}

}}
//echo $total2."<br>";
//echo $total2['sn'];



?>

Hope you have some knowledge on server side scripting language.. If you do, upload your work on a server, so we can help u out..

Its a civil matter, not criminal..

HungerBAD:
This is a good Judgement.

There is still hope in Nigeria. Where are the legal guys here?does this make Jim Iyke a convicted criminal since a court has found him wanting in a case of fraud?

Because its not real.. I live down the road from the market. Thats why am still wondering were nairaland got the news.

ufumes:
This news doesnt sound real cos, something of this magnitude should have been trending on twitter

What are you even saying sef??... Can't you see CN (cartoon network) at the bottom right?? Or must you embed conspiracy in everything... Nawa for you oo

Greatzeus:

This is a lie,have you ever watched a Hollywood movie where a full naked woman is rubbing the dick of a full naked man,talkless of a channel meant for kids.Everything on Air in America are highly regulated,not like Nigeria where kids,teenagers and adults watch the same movie.
If you go to the cinemas in America with your kids,if the movie is rated 18, your kids will never be allowed in.
Maybe this picture is from a cartoon porn,how would a kid channel be showing a naked woman rubbing the dick of a man live,common this is not on cartoon Network,big lie
Bloggers with no honour,this is not how those bloggers who made it big did it desperate attempt to come out of 20 visitors per day league