title: enum value not updating in mysql table?
body: <p>im using this script to update to columns in my table.</p>
  
  <p>the first column 'close_account' is an enum value '0' or '1' and these appear as radio boxes in my database.</p>
  
  <p>the second column 'account_status' is an enum value 'Active' or 'Deactivated' and this appears as a drop down box list in my database.</p>
  
  <p>i'm not sure if the fact that they are a drop down box or radio boxes matters in this case.</p>
  
  <p>however my problem is i am trying to get both close_account and account_status to update by running the following mysql query, close_account needs to update to '1' and account_status should update to 'Deactivated'. at the moment for some reason only 'close_account' is updating but not account_status can someone please tell me why?</p>
  
  <p>thanks.</p>
  
  <pre><code>&lt;? ob_start(); ?&gt;
  &lt;?php
  
  require_once('includes/session.php');
  require_once('includes/functions.php');
  require('includes/_config/connection.php');
  
  session_start();
  
      confirm_logged_in();
  
      if (isset ($_GET['to'])) {
      $user_to_id = $_GET['to'];
  
  
  }
  
  
  if (!isset($_GET['to']))
      exit('No user specified.');
  
  $user_id = $_GET['to'];
  
  
  $result = mysql_query("SELECT * FROM ptb_users WHERE user_id ='".$_SESSION['user_id']."' ");
  
  if($result) 
  { 
  mysql_query("UPDATE ptb_users SET close_account='1' WHERE user_id=".$_SESSION['user_id']."") 
  or die(mysql_error());
  
  mysql_query("UPDATE ptb_users SET account_status='Deactivated' WHERE user_id=".$_SESSION['user_id']."") 
  or die(mysql_error());
  
  header("Location: dashboard.php");
  
  }
  ?&gt;
  &lt;? ob_flush(); ?&gt;
  </code></pre>