I want to attach a condition to an updated record.
I have the following code:
<?php
if (isset($_POST["ProvningOmbokning2Knapp"]) || isset($_POST["ProvningOmbokning2Knapp_x"])) {
$UpdateQuery = new WA_MySQLi_Query($AboutBeer);
$UpdateQuery->Action = "update";
$UpdateQuery->Table = "Bokning";
$UpdateQuery->bindColumn("BokningProvningOmbokningAdmin", "i", "".((isset($_POST["Nyprovning"]))?$_POST["Nyprovning"]:"") ."", "WA_DEFAULT");
$UpdateQuery->bindColumn("BokningOmbokningsavgiftBetalning", "i", "".((isset($_POST["Ombokningsavgift"]))?$_POST["Ombokningsavgift"]:"") ."", "WA_DEFAULT");
$UpdateQuery->bindColumn("BokningOmbokningsdatumAdmin", "s", "", "WA_CURRENT_TIMESTAMP");
$UpdateQuery->addFilter("BokningRefnr", "=", "i", "".((isset($_POST["BokningRefnr"]))?$_POST["BokningRefnr"]:"") ."");
$UpdateQuery->execute();
$UpdateGoTo = "../provningar/ombokning-tack.php?BokningRefnr=".((isset($_POST["BokningRefnr"]))?$_POST["BokningRefnr"]:"") ."".(isset($_GET["pageNum_BokningRefnr"])?"&pageNum_BokningRefnr=".intval($_GET["pageNum_BokningRefnr"]):"") ."";
if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):"";
$UpdateQuery->redirect($UpdateGoTo);
}
?>
Now I want to add the following line with condition "$tidsskillnad > 72":
$UpdateQuery->bindColumn("BokningOmbokningBekraftadAdmin", "i", "1", "WA_DEFAULT");
I have tried to create a new update record that only has this update query and used show region utility around this new update record, but nothing happens.