title: INSERT into DB table with PDO prepare and bindParam
body: <p>In simple terms can someone explain what I am doing wrong here - I am simply trying to insert into a db with with prepare and bindParam, this is inserting 0 and Null into all the fields. </p>
  
  <pre><code>$sql = $db-&gt;prepare("INSERT INTO db_fruit VALUES (id=? ,type=? ,colour=?)");
  $sql-&gt;bindParam(1, $newId);
  $sql-&gt;bindParam(2, $type);
  $sql-&gt;bindParam(3, $colour);
  $sql-&gt;execute()
  </code></pre>
  
  <p>btw: this method has been working for me for UPDATE etc, but not in this case for INSERT</p>