title: mysql result not performing after query is run?
body: <p>Hi i have two query's here that run as part of a registration form, upon the user registering information is split into two tables, ptb_users and ptb_stats.</p>
  
  <p>Both query's are working ok. however both tables have an auto increment column, in ptb_users the column user_id is set to auto increment, and at the end of the query the user_id value is set to update/copy into ptb_users.id so that the user_id and id match. </p>
  
  <p>But in ptb_stats id is the auto increment column and again i have asked it to update/copy the value from id to user_id within the ptb_stats table.</p>
  
  <p>i am doing this by using this code:</p>
  
  <pre><code>$result = mysql_query("UPDATE ptb_users SET ptb_users.user_id=ptb_users.id");
   $result2 = mysql_query("UPDATE ptb_users SET ptb_stats.id=ptb_stats.user_id");
  </code></pre>
  
  <p>now for some reason this works on the first query ($result) where i am asking it to update ptb_users.user_id=ptb_users.id but it doesnt work on ($result 2) is there any reason why this is the case?</p>
  
  <pre><code>$query="INSERT INTO ptb_users (user_id,
  id,
  first_name,
  last_name,
  email )
  VALUES('NULL',
  'NULL',
  '".$firstname."',
  '".$lastname."',
  '".$email."'
  )";
  mysql_query($query) or dieerr();
  $result = mysql_query("UPDATE ptb_users SET ptb_users.user_id=ptb_users.id");
  
  
  $query="INSERT INTO ptb_stats (id,
  user_id,
  display_name )
  VALUES('NULL',
  'NULL',
  '".$username."'
  )";
  mysql_query($query) or dieerr();
  $result2 = mysql_query("UPDATE ptb_stats SET ptb_stats.id=ptb_stats.user_id");
  </code></pre>