Jump to content

Grading a column.


seyz4all

Recommended Posts

PLS HELP I WANT TO GRADE THE NEXT COLUMN IN A TABLE AND DONT KNOW WHAT TO DO

 

 

HERES WHAT I HAVE DONE SO FAR

 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>junior_class_scores</TITLE>
<META http-equiv=Content-Type content="text/html; charset=windows-1252"><LINK 
href="include/style.css" type=text/css rel=stylesheet>
<META content="MSHTML 6.00.2900.3132" name=GENERATOR></HEAD>
<BODY bgColor=white>{include_if_exists file="include/header.php"} 
<H1>
<H1><FONT face=Tahoma>VIEW SCORES</FONT></H1>
<H1>Junior Classes </H1></H1>{$message}{doevent name="ViewOnLoad"} 
<DIV align=left>
<HR width=300 noShade SIZE=1>
</DIV>   <A href="junior_class_scores_list.php?a=return">Back to 
list</A><BR><BR>
<TABLE cellSpacing=2 cellPadding=2 border=0>
  <TBODY>
  <TR>
    <TD class=shade width=99>TabNum</TD>
    <TD width=156>{$show_iTabNum} </TD>
    <TD width=144> </TD>
    <TD width=115> </TD>
    <TD width=146> </TD>
    <TD width=75> </TD></TR>
  <TR>
    <TD class=shade width=99>Surname</TD>
    <TD width=156>{$show_vSurname} </TD>
    <TD width=144> </TD>
    <TD width=115> </TD>
    <TD width=146> </TD>
    <TD width=75> </TD></TR>
  <TR>
    <TD class=shade width=99>FirstName</TD>
    <TD width=156>{$show_vFirstName} </TD>
    <TD width=144> </TD>
    <TD width=115> </TD>
    <TD width=146> </TD>
    <TD width=75> </TD></TR>
  <TR>
    <TD class=shade width=99>Othername</TD>
    <TD width=156>{$show_vOthername} </TD>
    <TD width=144> </TD>
    <TD width=115> </TD>
    <TD width=146> </TD>
    <TD width=75> </TD></TR>
  <TR>
    <TD class=shade width=99>Class</TD>
    <TD width=156>{$show_cClass} </TD>
    <TD width=144> </TD>
    <TD width=115> </TD>
    <TD width=146> </TD>
    <TD width=75> </TD></TR>
  <TR>
    <TD class=shade width=99>Term</TD>
    <TD width=156>{$show_cTerm} </TD>
    <TD width=144> </TD>
    <TD width=115> </TD>
    <TD width=146> </TD>
    <TD width=75> </TD></TR>
  <TR>
    <TD width=99> </TD>
    <TD width=156> </TD>
    <TD width=144> </TD>
    <TD width=115> </TD>
    <TD width=146> </TD>
    <TD width=75> </TD></TR>
  <TR>
    <TD style="BACKGROUND-COLOR: #7b7bc0" width=99>
      <P align=center> <STRONG><FONT 
      color=#ffffff>SUBJECTS</FONT></STRONG></P></TD>
    <TD style="BACKGROUND-COLOR: #7f7f7f" width=156>
      <P align=center><STRONG><FONT color=#ffffff>1ST CONTINOUS ACCESSMENT 
      TEST</FONT></STRONG> </P></TD>
    <TD style="BACKGROUND-COLOR: #7f7f7f" width=144>
      <P align=center><FONT color=#ffffff><STRONG>2ND CONTINOUS ACCESSMENT 
      TEST</STRONG></FONT> </P></TD>
    <TD style="BACKGROUND-COLOR: #7f7f7f" width=115>
      <P align=center><STRONG><FONT color=#ffffff>EXAM 
      SCORES</FONT></STRONG> </P></TD>
    <TD style="BACKGROUND-COLOR: #7f7f7f" width=146>
      <P align=center><FONT color=#ffffff><STRONG>TOTAL 
      SCORES</STRONG></FONT> </P></TD>
    <TD style="BACKGROUND-COLOR: #3cb371" width=75>
      <P align=center><STRONG><FONT 
    color=#ffffff>GRADE </FONT></STRONG></P></TD></TR>
  <TR>
    <TD class=shade width=99>Eng lish Language</TD>
    <TD width=156>{$show_iEngLang_CA1} </TD>
    <TD width=144> {$show_iEngLang_CA2}</TD>
    <TD width=115> {$show_iEngLang_Ex}</TD>
    <TD width=146> {$show_iEngLang_Total}</TD>
    <TD width=75> </TD></TR>
  <TR>
    <TD class=shade width=99>Mathematics</TD>
    <TD width=156>{$show_iMathematics_CA1} </TD>
    <TD width=144> {$show_iMathematics_CA2}</TD>
    <TD width=115> {$show_iMathematics_Ex}</TD>
    <TD width=146> {$show_iMathematics_Total}</TD>
    <TD width=75> </TD></TR>
  <TR>
    <TD class=shade width=99>Business Studies</TD>
    <TD width=156>{$show_iBussStud_CA1} </TD>
    <TD width=144> {$show_iBussStud_CA2}</TD>
    <TD width=115> {$show_iBussStud_Ex}</TD>
    <TD width=146> {$show_iBussStud_Total}</TD>
    <TD width=75> </TD></TR>
  <TR>
    <TD class=shade width=99>Social Studies</TD>
    <TD width=156>{$show_iSocStud_CA1} </TD>
    <TD width=144> {$show_iSocStud_CA2}</TD>
    <TD width=115> {$show_iSocStud_Ex}</TD>
    <TD width=146> {$show_iSocStud_Total}</TD>
    <TD width=75> </TD></TR>
  <TR>
    <TD class=shade width=99>Home Economics</TD>
    <TD width=156>{$show_iHomeEcons_CA1} </TD>
    <TD width=144> {$show_iHomeEcons_CA2}</TD>
    <TD width=115> {$show_iHomeEcons_Ex}</TD>
    <TD width=146> {$show_iHomeEcons_Total}</TD>
    <TD width=75> </TD></TR>
  <TR>
    <TD class=shade width=99>Introductory Technology</TD>
    <TD width=156>{$show_iIntroTech_CA1} </TD>
    <TD width=144> {$show_iIntroTech_CA2}</TD>
    <TD width=115> {$show_iIntroTech_Ex}</TD>
    <TD width=146> {$show_iIntroTech_Total}</TD>
    <TD width=75> </TD></TR>
  <TR>
    <TD class=shade width=99>Integrated Science</TD>
    <TD width=156>{$show_iIntScie_CA1} </TD>
    <TD width=144> {$show_iIntScie_CA2}</TD>
    <TD width=115> {$show_iIntScie_Ex}</TD>
    <TD width=146> {$show_iIntScie_Total}</TD>
    <TD width=75> </TD></TR>
  <TR>
    <TD class=shade width=99>C. R. K</TD>
    <TD width=156>{$show_iCrk_CA1} </TD>
    <TD width=144> {$show_iCrk_CA2}</TD>
    <TD width=115> {$show_iCrk_Ex}</TD>
    <TD width=146> {$show_iCrk_Total}</TD>
    <TD width=75> </TD></TR>
  <TR>
    <TD class=shade width=99>I. R. K</TD>
    <TD width=156>{$show_iIrk_CA1} </TD>
    <TD width=144> {$show_iIrk_CA2}</TD>
    <TD width=115> {$show_iIrk_Ex}</TD>
    <TD width=146> {$show_iIrk_Total}</TD>
    <TD width=75> </TD></TR>
  <TR>
    <TD class=shade width=99>Yoruba Language</TD>
    <TD width=156>{$show_iYoruba_CA1} </TD>
    <TD width=144> {$show_iYoruba_CA2}</TD>
    <TD width=115> {$show_iYoruba_Ex}</TD>
    <TD width=146> {$show_iYoruba_Total}</TD>
    <TD width=75> </TD></TR>
  <TR>
    <TD class=shade width=99>Igbo Language</TD>
    <TD width=156>{$show_iIgbo_CA1} </TD>
    <TD width=144> {$show_iIgbo_CA2}</TD>
    <TD width=115> {$show_iIgbo_Ex}</TD>
    <TD width=146> {$show_iIgbo_Total}</TD>
    <TD width=75> </TD></TR>
  <TR>
    <TD class=shade width=99>Pysical  Health Education</TD>
    <TD width=156>{$show_iPHE_CA1} </TD>
    <TD width=144> {$show_iPHE_CA2}</TD>
    <TD width=115> {$show_iPHE_Ex}</TD>
    <TD width=146> {$show_iPHE_Total}</TD>
    <TD width=75> </TD></TR>
  <TR>
    <TD class=shade width=99>French Language</TD>
    <TD width=156>{$show_iFrench_CA1} </TD>
    <TD width=144> {$show_iFrench_CA2}</TD>
    <TD width=115> {$show_iFrench_Ex}</TD>
    <TD width=146> {$show_iFrench_Total}</TD>
    <TD width=75> </TD></TR>
  <TR height=50>
    <TD align=left width=257 colSpan=2>   <A 
      href="junior_class_scores_list.php?a=return">Back to list</A><BR><BR></TD>
    <TD width=144> </TD>
    <TD width=115> </TD>
    <TD width=146> </TD>
    <TD width=75> </TD></TR></TBODY></TABLE>{include_if_exists file="include/footer.php"} </BODY></HTML>

 

PLS HELP ME OUT WITH THE CODE FOR THE GRADE COLUMNS...

 

Mod edit: code tags added

 

Link to comment
https://forums.phpfreaks.com/topic/61707-grading-a-column/
Share on other sites

ALL RIGHT

 

THE PROBLEM IS  THAT I ALREADY HAVE A COLUMN CALLED TOTAL.

 

$sql= SELECT *, column 1+column2+column3 as total;"

 

BUT THAT IS EMPTY IN THE DATABASE TABLE BUT SUMS UP THE TOTAL OF TWO OTHER COLUMNS

-I WANT THE GRADE COLUMN TO READ THE DATA IN THE TOTAL COLUMN ON THE PAGE TO DISPLAY GRADES SUCH AS A1, B2, C4 

 

WHEN 70-100, IT SHOULD READ A1.

 

THE TOTAL COLUMN IS EMPTY ON THE DATABASE TABLE, SO NO TRIGGER CAN CREATED TO SOLVE IT

 

pls help

Link to comment
https://forums.phpfreaks.com/topic/61707-grading-a-column/#findComment-307247
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.