i need to write a statement to check if the order exists already so if it does i dont run the INSERT query it just goes to the gateway
what i have so far does not work, im still getting the Duplicate error
Code: Select all
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
//check if an order already exists
$checkOrderID = $_SESSION['OrderID'];
mysql_select_db($database_beauSS15, $beauSS15);
$query_rsOrder = "SELECT OrderID FROM beau_orders WHERE OrderID = %s LIMIT 1";
$query_rsOrder = sprintf($query_rsOrder, $checkOrderID);
$results = mysql_query($query_rsOrder);
if(mysql_num_rows($results) > 0)
{
$row = mysql_fetch_array($results);
$checkOrderID = $row_rsOrder['OrderID'];
}
else
{
//end check if an order already exists
}
//additional bracket for check if an order already exists
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO beau_orders (OrderID, CustomerID, OrderDate, Shipping, Discount, Tax, Total, TransactResult, imx) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['OrderID'], "text"),
GetSQLValueString($_POST['CustomerID'], "int"),
GetSQLValueString($_POST['OrderDate'], "date"),
GetSQLValueString($_POST['Shipping'], "double"),
GetSQLValueString($_POST['Discount'], "double"),
GetSQLValueString($_POST['Tax'], "double"),
GetSQLValueString($_POST['XC_Amount'], "double"),
GetSQLValueString($_POST['TransactResult'], "text"),
GetSQLValueString($_POST['imx'], "int"));
mysql_select_db($database_beauSS15, $beauSS15);
$Result1 = mysql_query($insertSQL, $beauSS15) or die(mysql_error());
}