prepare("select * from class where classid =:snc") ; $chk->bindparam(":snc",$sname) ; $chk->execute() ; if($chk->rowcount() > 0) { $message[] = "This Class Has been Registered Before, Register Another Class" ; } else { //inserting record to table $sqlsubj = $DBcon->prepare( "insert into class (classid) values(:snc)") ; $sqlsubj->bindparam(":snc",$sname) ; if($sqlsubj->execute()) $message[] = "$sname ..Registered Succesfully" ; else $message[] = "There is a Problem Registering...$sname..Pls Try again " ; } } ?>