title: How to update multiple columns in SQL?
body: <p>hi am trying to update multiple column , how can i? the first column is shoe1, wanna add another column but cant</p>
  
  <pre><code>// shoe1
  $query = "SELECT shoe_id, shoes_image, 
           shoes FROM " . $DBPrefix . "shoes";
  
  $params[] = array(':shoe_id', floor($time_passed), 'int');
  $db-&gt;query($query, $params);
  
  $TPL_shoe1_list = '&lt;select name="shoe1"&gt;' . "\n";
  
  while ($row = $db-&gt;fetch())
  {
      $selected = ($row['shoes'] == $shoe1) ? 'selected="true"' : '';
      $TPL_shoe1_list .= "\t" . '&lt;option value="' . $row['shoes'] . '" ' . $selected . '&gt;' . $row['shoes'] .'&lt;/option&gt;' . "\n";
  }
  
  $TPL_shoe1_list .= '&lt;/select&gt;' . "\n";
  </code></pre>