runQuery("delete FROM allotee_biodata WHERE regno=:odn"); $stmt->bindparam(":odn",$odn) ; //delete nextof kin info $stmt1 = $dell->runQuery("delete FROM nextofkin WHERE regno=:odn"); $stmt1->bindparam(":odn",$odn) ; //delete from stall deail $stmt3 = $dell->runQuery("delete FROM stall_details WHERE regno=:odn"); $stmt3->bindparam(":odn",$odn) ; //delete from doc. $stmt4 = $dell->runQuery("delete FROM documents WHERE regno=:odn"); $stmt4->bindparam(":odn",$odn) ; //$stmt->execute(array(":odn"=>$username)); if($stmt->execute()) header("location: namesearch.php") ; }