title: Unknown column in field list
body: <p>I keep getting the error <code>Unknown Column in field List</code>.</p>
  
  <p>The database has these fields:</p>
  
  <pre><code>ID - AUTO INCRIMENT
  username
  password
  groupID
  prefs_list_item
  </code></pre>
  
  <p>Here is my code. The variables are stored above as a set value which I know isn't giving me any issue, because I use them in other databases in the same script.</p>
  
  <pre><code>try {
  $wpdb = new PDO('mysql:host=localhost; dbname=******', '*******', 
  '*******');
  $wpdb-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  
  //Creates the SQL statement to write into the picture database
  $pictureUPDATE = $wpdb-&gt;prepare
  ("INSERT INTO pe_users (
  username,
  password,
  groupID
  ) VALUES (
  $username,
  $passmd5,
  $groupID
  )
  ");
  //Executes the writing into the picture database
  $pictureUPDATE-&gt;execute();
  echo("&lt;p&gt;Your account to upload photos is now active!&lt;/p&gt;");            
                                          }
  //catches any errors that might have come from updating the picture databse
  catch (PDOException $ex) {
         $msg = $ex-&gt;errorInfo;
         error_log(var_export($msg, true));
         die("&lt;p&gt;Sorry, there was a unrecoverable database error with PICTURES.  
         Debug data has been logged.&lt;/p&gt;");
                           }
  </code></pre>
  
  <p>Not sure what's going on, anyone have a clue?</p>