PHP inserts another value into the database!
Posted: Mon Jan 22, 2007 9:04 am
Hello,
$item_number is one value but the MySQL querey inserts another.
$item_number = 110079832134, and that's also the item number that is emailed to be. But when I look at the database 2147483647 has been inserted instead!? And it always inserts 2147483647 instead of the actual number so please help me, what's wrong?? The database ebay_item_id is int(15).
Thanks in advance,
/Oskar R
$item_number is one value but the MySQL querey inserts another.
Code: Select all
Here is the code:
$item_number = $_POST['item_number'];
$sql46="INSERT INTO $sales_tbl (user_id, pack_id, ebay_item_name, ebay_item_id, ebay_txn_id, shipped_marked, paid_marked, payment_status, payment_date, payment_gross, payment_tax, payment_currency, payment_type, paypal_txn_id, paypal_memo, auction_closing_date, auction_multi_item, received) VALUES('".$row['user_id']."', '".$ident_row['file_id']."', '$item_name', '$item_number', '$ebay_transaction_id', '$shipped_marked', '$paid_marked', '$payment_status', '$payment_date', '$mc_gross', '$tax', '$mc_currency', '$payment_type', '$txn_id', '$memo', '$auction_closing_date', '$auction_multi_item', NOW())";
$result46=mysql_query($sql46) or die( mysql_error() );
}
//Send new purchase message to buyer
$to = "me@me.com";
$subject = 'subject';
$message = "
Item number: $item_number
";
$headers = 'From: sales@ventiero.com' . "\r\n" .
'Reply-To: sales@ventiero.com' . "\r\n" .
'X-Mailer: PHP/' . phpversion();
mail($to, $subject, $message, $headers);Thanks in advance,
/Oskar R