Jump to content

Ronbo51

New Members
  • Posts

    2
  • Joined

  • Last visited

Community Answers

  1. Ronbo51's post in "The number of variables must match the number of parameters in a prepared statement" was marked as the answer   
    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.
×
×
  • Create New...

Important Information

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.