title: It is not updating the row in table PDO
body: <p>Can someone tell me why this code is not updating the the column in these rows please</p>
  
  <pre><code>$q2 = $db-&gt;prepare("insert into stat (clan_id,abbreviation) values (:cid,:abb) ON DUPLICATE KEY UPDATE abbreviation=:abb");
              $q2-&gt;execute(array(
                  ":cid"=&gt;$somevalue,
                  ":abb"=&gt;$abbrev
                  ));
  </code></pre>
  
  <p>abbreviation is my unique key in this table, there are more values but I removed some for clarity.</p>
  
  <p>Edit:
  Problem still exists, the PDO is adding new entries, however when it comes across a duplicate it is not updating</p>
  
  <p>here is the table structure, there maybe something wrong here?</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `stats` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `clan_id` varchar(168) NOT NULL,
    `abbreviation` varchar(64) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `abbreviation` (`abbreviation`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=155146 ;
  </code></pre>