title: PHP PDO increment
body: <p>I have to 2 questions:
   1.My problem is that when I try to increment the value is reset back to 1 ;
   2.Can I reduce my code to a MYSQL statement (the switch ... case code)</p>
  
  <pre><code>public static function process($nr,$id) // (x,y,z,a,b ?) (the column id)
  {
  
  $х=$y=$z=$a=$b=0;
  
    switch ($nr) {
      case '1':
          $х=1;
          break;
  
          case '2':
          $y=1;
          break;
  
          case '3':
          $z=1;
          break;
  
          case '4':
          $a=1;
          break;
  
          case '5':
          $b=1;
          break;
  
    }
  
  
  
  
  $conn = new PDO( DBN, DB_USER, DB_PASS );
  $sql = "UPDATE test_table SET b=+:b, a=+:a,z=+:z,y=+:y,х=+:х WHERE id = :id";
  $st = $conn-&gt;prepare ( $sql );
  $st-&gt;bindValue( ":id", $id, PDO::PARAM_INT);
  $st-&gt;bindValue( ":х", $х, PDO::PARAM_INT);
  $st-&gt;bindValue( ":y", $y, PDO::PARAM_INT);
  $st-&gt;bindValue( ":z", $z, PDO::PARAM_INT);
  $st-&gt;bindValue( ":a", $a, PDO::PARAM_INT);
  $st-&gt;bindValue( ":b", $b, PDO::PARAM_INT);
  $st-&gt;execute();
  $conn = null;
  print_r($st-&gt;errorInfo());
  </code></pre>
  
  <p>}</p>