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