title: mysql database insert is changing all IDs to 4294967295
body: <p>Something really weird is going on with my database. I am using PHP to insert data into my database and I have been doing this for the past 2 years without any problems. When a customer makes a payment on my website, I store all of the data from that transaction in my database. Each transaction has a unique "transaction_id". When I insert the payment information into the database, all of the information is correctly inserted except for the "transaction_id". ALL transactions are given the "transaction_id" of "4294967295".  So I did some testing. Here is what I did:</p>
  
  <p>1) I echoed out the "transaction_id" to my screen to see what is would say. The results were that the "transaction_id" that was being echoed out was CORRECT. It was not the repeating "4294967295". However, when I look in my database, it shows "4294967295". </p>
  
  <p>2) This time I decided to echo out the query to my web browser. The query was CORRECT. In the query, the CORRECT "transaction_id" was in the query. However, when I look in my database, it shows "4294967295".</p>
  
  <p>I have 3 different pages where customers can make payments. ALL 3 pages started doing this on April 6th, 2012. None of those pages were modified at all. I have not modified those pages in over 2 years. Any help is greatly appreciated!</p>
  
  <pre><code>$query = "INSERT INTO payments (customer_id, transaction_id, invoice_number, authorization_code, subscription, subscription_id, avs_result, cvv_result, amount, full_tuition, payment_date, ip_address) VALUES ({$_SESSION['customer_id']}, {$_SESSION['transaction_id']}, {$_SESSION['invoice_number']}, '{$_SESSION['authorization_code']}', '{$_SESSION['subscription']}', {$_SESSION['subscription_id']}, '{$_SESSION['avs_result']}', '{$_SESSION['cvv_result']}', {$_SESSION['amount']}, {$_SESSION['full_tuition']}, '{$_SESSION['payment_date']}', '{$_SESSION['ip_address']}')" ;
  $result = mysqli_query($dbc, $query) OR die ('&lt;p&gt;There was an error with the INSERT payments query.: ' . mysqli_error($dbc) . '&lt;br /&gt;Query:' . $query . '&lt;/p&gt;') ;
  
  echo '&lt;p&gt;Transaction ' .  $_SESSION['transaction_id'] . ' has been &lt;font color="green"&gt;APPROVED&lt;/font&gt; by the system.&lt;/p&gt;' ;
  
  echo '&lt;br /&gt;&lt;br /&gt;' ;
  
  echo '&lt;p&gt;Below is a summary:&lt;/p&gt;' ;
  echo '&lt;p&gt;Transaction ID: ' .  $_SESSION['transaction_id'] . '&lt;br /&gt;
  Payment Method: XXXX&lt;br /&gt;
  Amount: $' . $amount . '&lt;br /&gt;
  Customer Name: ' . $_SESSION['first_name'] . ' ' . $_SESSION['last_name'] . '&lt;br /&gt;
  &lt;/p&gt;' ;
  
  echo "&lt;p&gt;Note: Please do NOT click the browser's Back button to enter a new transaction.&lt;/p&gt;" ;
  
  
  echo $query ;
  </code></pre>