Update database with eCart Summary creates new OrderID and therefore a new record only if any data changes - why new record?

When I first update the database with eCart Summary a new OrderID (set to autonumber in the database) is created along with it's record and the fields are populated. This looks fine.

But, when the update to database happens again I find there are two scenarios (session ID same for both):
1) if no data changes, no new OrderID is generated, populated fields remain unchanged, that's fine.
2) if there are any data changes (eg. addresss), then a new record is created with a new Order ID and the fields updated
... is this the way it should work in 2)? I thought the initial record created would be updated rather than a new record created with a new OrderID

I believe I have set up the Order ID session variable correctly for the OrderID used in the database.

It should be updating the old order unless the session is cleared. If you give me a url to reproduce and FTP access I can debug it and see what is going on.

// WA eCart Store Cart Summary in MySQLi Db
if (isset($_POST["submit_ship_bill_address"]) || isset($_POST["submit_ship_bill_address_x"])) {
$ConditionalQuery = new WA_MySQLi_Query($alba_med_i);
$ConditionalQuery->Action = "conditional";
$ConditionalQuery->Table = "orders_ords";
$ConditionalQuery->saveInSession("eCartdefOrderID");
$ConditionalGoTo = "";
if (function_exists("rel2abs")) $ConditionalGoTo = $ConditionalGoTo?rel2abs($ConditionalGoTo,dirname(__FILE__)):"";
$ConditionalQuery->redirect($ConditionalGoTo);
if (isset($_SESSION[$ConditionalQuery->SaveAs])) $ConditionalQuery->addFilter("ID_ords", "=", "d", $_SESSION[$ConditionalQuery->SaveAs]);

Also, I only do the summary saving to database, no details yet. Right now just want to get the summary working.

And, I changed the saveInSession variable name and sometimes the old name pops up. I've checked to ensure my testing server files are in sync. Does the saveInSession variable get saved in some other WA file? (Just guessing, doubt it.)

Thanks

I wonder if you need to start the session on the top of the page?

This code looks correct.

1) 1st run of eCart summary to database ... Order ID session variable created as 46 ... database row with Order ID 46 is updated
2) 2nd run, same session ID ... Order ID session variable created as 5 ... database row with Order ID 46 is updated
3) 3rd run, same session ID ... Order ID session variable created as 47 ... database row with Order ID 47 is updated
4) 4th run, same session ID ... Order ID session variable created as 5 ... database row with Order ID 47 is updated
5) 5th run, same session ID ... Order ID session variable created as 48 ... database row with Order ID 48 is updated
... see the pattern.

Based on this, do see what may be the problem?

Note: OrderID in the eCart Summary database is INT and autonumber ... while OrderID in eCart Summary to database wizard is "number" and not a assigned a value

and got the message "Notice: Undefined offset: 4 in C:\xampp\htdocs\develop_new\webassist\mysqli\rsobj.php on line 312" (twice on top of page)

But the update to the database still worked. However I experienced the same as before (see my last post) where new Order ID session numbers were being created on updates.

Can you send me FTP access and a url to reproduce the problem? I'll need to debug to figure out why this is happening.

At this point I'm hesitant to provide FTP access ... I'm concerned about security - probably shouldn't though.

Here's code from a scenario I made to demo the problem. I made it as simple as possible (only saving one item, a session value, to the d/b) ... can you see anything from this?:

You can try this updated query object and see if it helps. It doesn't appear to me that you are doing anything wrong. I'd need FTP access to fully debug.

I implemented the updated query object. It didn't make a difference.

However, upon setting up something for you to see online I think I may have identified, or am getting closer, to understanding the problem. It may have to do with having a dynamic connection (in my mind I think it is unlikely) or may have to do with Session ID's "clashing" between local host (XAMPP in my case) and my ISP account. I dunno, but I'm going to park this matter for now ... I think the answer will come up after I keep at it.

So, thanks for trying to help. I'll get back to you on this only if I get stonewalled in the future.