BarneyJoe Posted November 14, 2007 Share Posted November 14, 2007 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? Quote Link to comment Share on other sites More sharing options...
teng84 Posted November 14, 2007 Share Posted November 14, 2007 post the real code Quote Link to comment Share on other sites More sharing options...
BarneyJoe Posted November 14, 2007 Author Share Posted November 14, 2007 I thought that was the code. What's the real code? ??? Quote Link to comment Share on other sites More sharing options...
BarneyJoe Posted November 14, 2007 Author Share Posted November 14, 2007 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()); } Quote Link to comment Share on other sites More sharing options...
BarneyJoe Posted November 15, 2007 Author Share Posted November 15, 2007 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.