Thank you very much requinix for your quick reply and help. I changed the code to what is shown below and now it works.
$sql = "UPDATE missionaries SET missionary=?, active=?, country=?, city=?, state=?, zip=?, street=?, phone=?,email=?,
website=?, facebook=?, photo=? WHERE ID=?";
$stmt = $con->prepare($sql);
$stmt->bind_param("ssssssssssssi", $missionary,$active,$country,$city,$state,$zip,$street,$phone,$email,$website,$facebook,$photo,$id);
I definitely do not to change the ID. The ID input statement is type=hidden so it can't be changed. I thought I had to include it but I now see that I don't have to. This prepared statement programing is all new to me and you have helped me a lot. Thanks again.
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.