shadowskill

s

$rem1 = "UPDATE `subjecttaken` SET `Remarks`= 'FAILED' WHERE `Grade` < '75' and `SNum`='$SNum' "; mysql_query($rem1); $rem2 = "UPDATE `subjecttaken` SET `Remarks`= 'PASSED' WHERE `Grade` > '75' and `SNum`='$SNum' "; mysql_query($rem2); $rem3 = "UPDATE `subjecttaken` SET `Remarks`= 'No Grade' WHERE `Grade` = '' and `SNum`='$SNum' "; mysql_query($rem3); $rem4 = "UPDATE `subjecttaken` SET `Remarks`= 'PASSED' WHERE `Grade` = '75' and `SNum`='$SNum' "; mysql_query($rem4); $rem5 = "UPDATE `subjecttaken` SET `Remarks`= 'INCOMPLETE' WHERE `Grade` = 'INC' and `SNum`='$SNum' "; mysql_query($rem5); My problem about this is it loads too long so im guessing its because of i have lots to update? There is a possibility of combing all of them into one right? That will also lessen the loading?

Hello good day, this is what my Database looks like and my problem is i cannot figure out what SQL Query i should use. I have already solve the part where my evaluation would become "Done" and "Must Be Taken" and here are my Queries UPDATE `column_table` SET `Evaluation`= 'Done' WHERE `Remarks` = 'PASSED' UPDATE `column_table` SET `Evaluation`= 'Must be taken' WHERE `SubjectPrerequisite ` = 'None' AND `Remarks` = 'FAILED' UPDATE `column_table` SET `Evaluation`= 'Must be taken' WHERE `SubjectPrerequisite ` = 'None' AND `Remarks` = 'No Grade' The problem is my last query where it will UPDATE the database to "Cannot be taken" when the SubjectPrerequisite's Remarks = FAILED or Grade = 'No Grade' column_table ______________________________________________________________________________________ SubjectName | SubjectPrerequisite | Grade | Remarks | Evaluation ______________________________________________________________________________________ Fil 1 | None | | No Grade | Must be taken Eng 1 | None | 90 | PASSED | Done Eng 2 | Eng 1 | 74 | FAILED | Must be taken Eng 3 | Eng 2 | | No Grade | Cannot be taken Fil 2 | Fil 1 | | No Grade | Cannot be taken ______________________________________________________________________________________ Please tell me if your having a hard time understanding my explanation guys. Thank you very much