unstable confirm page, does't update order table

based on the pervious post:
http://www.webassist.com/forums/posts.php?id=31929

the confirmation page works in passing the details to paypal but the order table doesn't always update the Order table address details

I also looked at this posting and I adjusted the code

http://www.webassist.com/forums/posts.php?id=26861

but after the first attempt it works and then the order table problem comes back again.

You probably just have to clear the orderID session variable on the success page to force it to create a new record for the second transaction.

If that was the case, even if I close the browser or test using a different browser on a different machine would generate a different session,I'm still not getting any joy.

Also other entries such as the order date and customer id would not be updated.

Also look at order ID 6 part of the database is updated

I think I've found the problem, it's not the session order ID

it's to do you the order of the code blocks when the confirm page pulls the shipping address variables from the checkout page.

for example:

block like this (creating session variables from $_post data) must be declared first:

<?php

if (!session_id()) session_start();

if($_SERVER["REQUEST_METHOD"] == "POST")     {

  $_SESSION["eCartCheckoutForm_firstname"] = "".((isset($_POST["firstname"]))?$_POST["firstname"]:"")  ."";

}

?>

Then the order summary (code block starting with):

<?php 

// WA eCart Store Cart Summary in Db

if ($_SERVER["REQUEST_METHOD"] == "POST") // Trigger

{

  $WA_connection = $database01;

  $WA_table = "tb_Orders";

  $WA_redirectURL = "";

  $WA_indexField = "intOrderID";

  $WA_fieldNamesStr =

OK... glad you were able to figure it out. Let us know if you have any more questions or issues after the update.