seyz4all Posted July 25, 2007 Share Posted 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 Link to comment https://forums.phpfreaks.com/topic/61707-grading-a-column/ Share on other sites More sharing options...
Barand Posted July 25, 2007 Share Posted 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. Link to comment https://forums.phpfreaks.com/topic/61707-grading-a-column/#findComment-307210 Share on other sites More sharing options...
seyz4all Posted July 25, 2007 Author Share Posted 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 Link to comment https://forums.phpfreaks.com/topic/61707-grading-a-column/#findComment-307247 Share on other sites More sharing options...
Barand Posted July 25, 2007 Share Posted 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 Link to comment https://forums.phpfreaks.com/topic/61707-grading-a-column/#findComment-307249 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.