title: mysql updates not working
body: <p>I have a mysql insert function that works whenever I insert data into a database, but my mysql update function for some reason doesn't seem to work... it doesn't return any data... just zilch... not even an error message... here's the code: hopefully you can figure out why it's not responding by upgrading the database - primary column/key here is "id" or "$id" - which auto increment itself - I changed the id to pop out random values as well - still get same results... here's the code - hopefully you can fix it up!</p>
  
  <pre><code>    if ((isset($_POST["submitd"]) &amp;&amp; $_POST["submitd"] == "Save" ) &amp;&amp; (strlen((string)$id)==0)&amp;&amp; (strlen($first_name)&gt;0) &amp;&amp; (strlen($middle_names)&gt;0) &amp;&amp; (strlen($last_name)&gt;0) &amp;&amp; (strlen($street)&gt;0) ){
  
      $full_name = $first_name." ".$middle_names." ".$last_name;
  
   $query567="INSERT into records(id,full_name, first_name, middle_names, last_name, street) VALUES('$id','$full_name','$first_name', '$middle_names', '$last_name', '$street');";
   $vttvk = $dbs -&gt; prepare($query567);
   $vttvk -&gt; execute(array(':id'=&gt;$id,':full_name'=&gt;$full_name,':first_name'=&gt;$first_name,':middle_names'=&gt;$middle_names,':last_name'=&gt;$last_name,':street'=&gt;$street));
  
      }
  else {  
      $query257 = "UPDATE records SET `full_name`=?,`first_name`=?, `middle_names`=?,`last_name`=?,`street`=? WHERE `id`=?";
  
      $opztyz51 = $dbs-&gt;prepare($query257);
  
      $opztyz51 -&gt;execute(array($full_name, $first_name,$middle_names, $last_name, $street, $id));
  }
  </code></pre>
  
  <p>I hope you can help fix this up....</p>