[SOLVED] Updating a field

[BarneyJoe]

I'm just trying to edit some code to update a field in an orders table with a transaction code that wasn't there before, using some code in the return.php page.

 

At the moment it updates the the order status field using the code :

 

mysql_select_db($database_connOriental, $connOriental);
  $Result1 = mysql_query($updateSQL, $connOriental) or die(mysql_error());
}

if ("" == "") {
  $updateSQL = sprintf("UPDATE Orders SET OrderStatus=%s, WHERE OrderID=%s",
                       GetSQLValueString("Accepted", "text"),
                       GetSQLValueString($_SESSION['OrderNumber'], "int"));
//die($updateSQL);
  mysql_select_db($database_connOriental, $connOriental);
  $Result1 = mysql_query($updateSQL, $connOriental) or die(mysql_error());
}

 

The transaction code appears on the page as :

 

$VendorTxCode = $values['VendorTxCode'];

 

and correctly displays using :

 

<? echo ($VendorTxCode); ?>

 

So I thought I needed to change the update code to :

 

mysql_select_db($database_connOriental, $connOriental);
  $Result1 = mysql_query($updateSQL, $connOriental) or die(mysql_error());
}

if ("" == "") {
  $updateSQL = sprintf("UPDATE Orders SET OrderStatus=%s WHERE OrderID=%s", VendorTxCode=%s
                       GetSQLValueString("Accepted", "text"),
	       GetSQLValueString($_POST['VendorTxCode'], "text"),
                       GetSQLValueString($_SESSION['OrderNumber'], "int"));
//die($updateSQL);
  mysql_select_db($database_connOriental, $connOriental);
  $Result1 = mysql_query($updateSQL, $connOriental) or die(mysql_error());
}

 

But no joy - am I barking up the right tree with this?

[teng84]

post the real code

[BarneyJoe]

I thought that was the code.

 

What's the real code?

???

 

 

[BarneyJoe]

Although I did have a typo in the second part - should have been :

 

mysql_select_db($database_connOriental, $connOriental);
  $Result1 = mysql_query($updateSQL, $connOriental) or die(mysql_error());
}

if ("" == "") {
  $updateSQL = sprintf("UPDATE Orders SET OrderStatus=%s, VendorTxCode=%s WHERE OrderID=%s"
                       GetSQLValueString("Accepted", "text"),
	       GetSQLValueString($_POST['VendorTxCode'], "text"),
                       GetSQLValueString($_SESSION['OrderNumber'], "int"));
//die($updateSQL);
  mysql_select_db($database_connOriental, $connOriental);
  $Result1 = mysql_query($updateSQL, $connOriental) or die(mysql_error());
}

[BarneyJoe]

Got this working finally - think it might have been because the code updating the database was before the code that unpacked the encrypted fields back from the payment processor.