It is not updating the row in table PDO
<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>
