I did it the way you suggested and it works with the exception of when it redirects to the URL. It adds extra characters.
Example: https://awinninglook.com gets changed to https://&/#x2F;/awinninglook.com
Code Below:
<?php require_once('Connections/connSiteDB.php'); ?>
<?php require_once('webassist/mysqli/rsobj.php'); ?>
<?php require_once('webassist/mysqli/queryobj.php'); ?>
<?php
$rsAdvertisment = new WA_MySQLi_RS("rsAdvertisment",$connSiteDB,1);
$rsAdvertisment->setQuery("SELECT * FROM advertisements WHERE adID = ?");
$rsAdvertisment->bindParam("i", "".(isset($_GET['adID'])?$_GET['adID']:"") ."", "-1"); //colname
$rsAdvertisment->execute();
?>
<?php $link = ($rsAdvertisment->getColumnVal("adLink")); ?>
<?php
if (!($rsAdvertisment->TotalRows === 0)) {
$InsertQuery = new WA_MySQLi_Query($connSiteDB);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "advertisementcounter";
$InsertQuery->bindColumn("adcountAdID", "i", "".($rsAdvertisment->getColumnVal("adID")) ."", "WA_BLANK");
$InsertQuery->saveInSession("adcountID");
$InsertQuery->execute();
$InsertGoTo = "$link";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>
<form method="post" id="AdCounterForm" title="AddCounterForm">
<input name="adID" type="hidden" id="adID" value="<?php echo($rsAdvertisment->getColumnVal("adID")); ?>">
</form>
