Hi Ray
Thanks for your fast reply. I do have the OrderID in a session (Bestellnummer) but there is another session fromthe eCart that generates a OrderReferenceID: session_id() . And this session is always alive for the ecart. How can I remove it after finishing the order?
<?php
// WA eCart Store Cart Summary in MySQLi Db
if (isset($_POST["BestellungBtn"]) || isset($_POST["BestellungBtn_x"])) {
$ConditionalQuery = new WA_MySQLi_Query($ullri_2015_i);
$ConditionalQuery->Action = "conditional";
$ConditionalQuery->Table = "orders";
$ConditionalQuery->saveInSession("Bestellnummer");
$ConditionalGoTo = "";
if (function_exists("rel2abs")) $ConditionalGoTo = $ConditionalGoTo?rel2abs($ConditionalGoTo,dirname(__FILE__)):"";
$ConditionalQuery->redirect($ConditionalGoTo);
if (isset($_SESSION[$ConditionalQuery->SaveAs])) $ConditionalQuery->addFilter("OrderID", "=", "d", $_SESSION[$ConditionalQuery->SaveAs]);
$ConditionalQuery->bindColumn("OrderReferenceID", "s", "".session_id() ."", "WA_DEFAULT");
$ConditionalQuery->bindColumn("OrderSubtotal", "d", "".$eCartUllrich->TotalColumn("TotalPrice") ."", "WA_DEFAULT");
...
It's the ecart > [Session ID] that can be selected in the server entity panel