Grading a column.

seyz4all · July 25, 2007

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

Barand · July 25, 2007

1 ) Don't shout, use lower case.

2 ) Use code tags.

3 ) Tell us what your problem is. Don't just post a load of code saying "It doesn't work".

Maybe then we can help.

seyz4all · July 25, 2007

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

Barand · July 25, 2007

You're still shouting.

And I already gave you an answer to that problem here

http://www.phpfreaks.com/forums/index.php/topic,151245.msg653321.html#msg653321

Sign In

Grading a column.

Recommended Posts

seyz4all

Link to comment

Share on other sites

Barand

Link to comment

Share on other sites

seyz4all

Link to comment

Share on other sites

Barand

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information