eCart3_OrderID - is not being saved in session and orderdetail table.

eCart3_OrderID - this session isn't getting the order id that is being saved in the orders table...

I've changed my database so that the order id is populated with a text field variable (Date|time|session) ; the confirm.php isn't receiving the session when it saves the order details in the database.

The session dump displays this: ["eCart3_OrderID"]=> int(0)

Any ideas what I should I try to fix this?

send a copy of the confirm page.

PM below.

try changing line 396:
$_SESSION[$WA_sessionName] = mysql_insert_id();

to:
$_SESSION[$WA_sessionName] = mysql_insert_id($WA_connection);

No, that didn't do it.

Using the default orderdetails table from the wizard, it would normally just set the Session to the id that's entered into that table; it receives that variable from the orders table which is normally an integer. In my case, both of those ID fields are varchar. That doesn't matter, does it?

Is the page able to set the eCart3_OrderID session variable after saving to the orders table and before the details table?

<?php echo ((isset($_SESSION["eCart3_OrderID"]))?$_SESSION["eCart3_OrderID"]:""); ?>

In other words, do I need to have this set before I write to the orders table?

  both of those ID fields are varchar. That doesn't matter, does it?  

yes, it does matter, the ID fields must be integers.

in the orders table, the ID field needs to also be set to auto increment.

The code uses mysql_insert_id(); to look up the auto increment value when the record is inserted.

if you have the ID column set to varchar, it wont be able to auto increment, it needs to be an integer to be able to auto increment.

That did it. Thanks again for helping out; I appreciate it.

you're welcome.

One question about the <pre><?php var_dump($_SESSION); ?></pre>. When I put it on the checkout_success page, in one section, it's returning what looks like every product in my database. Is that what you'd expect it to do?