Couple of other issues with this...
1) Whilst the order amount is stored in database correctly, when I call this on my page via a recordset it displays like this:
2) When I get a receipt from Sage Pay I get the following:
The unique reference for this transaction is: 144076694575837450
Is this the TransactionCode, TransactionID, SecurityKey, AuthorizationNumber or SignatureString?
3) Ray, it's my son's birthday today and I really can't hang about this evening but I am desperate to get this issue resolved. I have listed, below, Sage Pay test MasterCard credentials for your reference which I have been running test transactions with successfully.
4) When you arrive at checkout_success.php it is displaying nicely however I changed the page slightly and then clicked Refresh. What happened was the order number changed! :( I know it's unlikely anyone is going to hit Refresh at that point but maybe you'd take a look at that for me?
Really appreciate it. Thank you.
EDIT: Still hoping to hear back from regarding this issue. None of the Sage Pay information is being saved to database. Thank you.