$sql = ("UPDATE member_registration SET fname=:fname,oname=:oname,mname=:mname,gfname=:gfname,gmname=:gmname,rank=:rank,state=:state,village=:village,lga=:lga,workingp=:workingp,dob=:dob;,ocupation=:ocupation,family_group=:family_group,nowives=:nowives,nochild=:nochild,gender=:gender,mstatus=:mstatus,cadres=:cadres,passport=:passport, where phn=$phn");
$stmt = $con->prepare($sql);
$stmt->bindParam('ocupation',$ocupation);
$stmt->bindParam('fname',$fname);
$stmt->bindParam('oname',$oname);
$stmt->bindParam('mname',$mname);
$stmt->bindParam('gfname',$gfname);
$stmt->bindParam('dob',$dob);
$stmt->bindParam('mstatus',$mstatus);
$stmt->bindParam('gender',$gender);
$stmt->bindParam('gmname',$gmname);
$stmt->bindParam('village',$village);
$stmt->bindParam('state',$state);
$stmt->bindParam('lga',$lga);
$stmt->bindParam('family_group',$family_group);
$stmt->bindParam('nowives',$nowives);
$stmt->bindParam('nochild',$nochild);
$stmt->bindParam('cadres',$cadres);
$stmt->bindParam('rank',$rank);
$stmt->bindParam('workingp',$workingp);
$stmt->bindParam('passport',$ppt);
$stmt->execute();
echo "alert('Update Succesfully');";
echo "window.location='report.php';";
What I have tried:
I am try to update a single record but all record got updated at the same time.