prepare("select * from subjno where (classlevel = '$gname' AND term = '$term') and yr = '$yr'") ; $sqlcheck->execute() ; if($sqlcheck->rowcount() > 0) { $msg[] = $gname.'...Level Minimum Subject has been Registered Before' ; } else { //inserting record to table $sql =$DBcon->prepare("insert into subjno (classlevel,nos,term,yr) values ('$gname','$start','$term','$yr') ") ; if($sql->execute()) { $msg[] = $gname.'...Level Minimum Subject Registered Succesfully in Database' ; } } } ?>
PREVIEW |
|||
| CLASS LEVEL | TERM | YEAR | NO OF SUBJECTS |
| ". $row['classlevel'] ." | " ; echo "". $row['term'] ." | " ; echo "". $row['yr'] ." | " ; echo "". $row['nos'] ." | " ; echo "