dynamic redirect after MySQLi record insert
Hi Ray,
I need to redirect to a URL after the record is inserted. This is what I have:
<?php
if ("" == "") {
$InsertQuery = new WA_MySQLi_Query($connBLUR_i);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "outbound";
$InsertQuery->bindColumn("clientid", "i", "".($rsOut->getColumnVal("clientid")) ."", "WA_DEFAULT");
$InsertQuery->saveInSession("outbound");
$InsertQuery->execute();
$InsertGoTo = "$rsOut->getColumnVal("website")";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>
$InserGoTo is pulling the url from the recordset, but this is not the correct code but I not sure what I am missing.
thx
Eric