$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