I've included the mysqli update records on a page and nothing is happening
I've put in a URL to go to after updating, and it does redirect, but the script seems to skip the updating part.
Here is the code : pretty standard code from you.
if ((((isset($_POST["updateme"]))?$_POST["updateme"]:"") != "")) {
$UpdateQuery = new WA_MySQLi_Query($ehs);
$UpdateQuery->Action = "update";
$UpdateQuery->Table = "evenements";
$UpdateQuery->bindColumn("etitre", "s", "".((isset($_POST["etitre"]))?$_POST["etitre"]:"") ."", "WA_DEFAULT");
$UpdateQuery->bindColumn("esoustitre", "s", "".((isset($_POST["esoustitre"]))?$_POST["esoustitre"]:"") ."", "WA_DEFAULT");
$UpdateQuery->bindColumn("edescription", "s", "".((isset($_POST["edescription"]))?$_POST["edescription"]:"") ."", "WA_DEFAULT");
$UpdateQuery->bindColumn("edescmini", "s", "".((isset($_POST["edescmini"]))?$_POST["edescmini"]:"") ."", "WA_DEFAULT");
$UpdateQuery->bindColumn("edate", "t", "".((isset($_POST["edate"]))?$_POST["edate"]:"") ."", "WA_DEFAULT");
$UpdateQuery->bindColumn("edate2", "t", "".((isset($_POST["edate2"]))?$_POST["edate2"]:"") ."", "WA_DEFAULT");
$UpdateQuery->bindColumn("emod", "t", "$today", "WA_DEFAULT");
$UpdateQuery->bindColumn("etype", "s", "".((isset($_POST["etype"]))?$_POST["etype"]:"") ."", "WA_DEFAULT");
$UpdateQuery->bindColumn("eactive", "c", "".((isset($_POST["eactive"]))?$_POST["eactive"]:"") ."", "WA_DEFAULT");
$UpdateQuery->bindColumn("epic", "s", "$lefilename", "WA_DEFAULT");
$UpdateQuery->addFilter("eid", "=", "i", "".($_POST['eid']) ."");
$UpdateQuery->execute();
$UpdateGoTo = "";
if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):"";
$UpdateQuery->redirect($UpdateGoTo);
}
So what could be going wrong? I'm using the same connection script as used for grabbing data from the db so that should work the same, no? And if not, I'd expect some type of error message. So what could be happening here?
Thanks very much,
George
