title: Int value changes when insert into mysql database - php
body: <p>I have a table in mysql with a field called "userId":</p>
  
  <pre><code>`userId` int(20) NOT NULL
  </code></pre>
  
  <p>Insert statement is:</p>
  
  <pre><code>$result = mysql_query("INSERT INTO users (userId, firstName, lastName, dateCreated) VALUES (".$me['userId'].", '".$me['first_name']."', '".$me['last_name']."', CURDATE()) ")or die(mysql_error());
  </code></pre>
  
  <p>The value of userId when echoed in php is 100000517980247, but when inserted it changes to 2147483647. When I insert it into a varchar field it's fine. This has to be something really simple but I searched around a bit and I'm just not seeing it.</p>