Count Advertisement Clicks

I have dynamic advertisement images that show up on a page. I also have a database table advertisementcounter with two fields adcountID and adcountAdID.

The advertisements are pulled in from the database and displayed as jpg images. I already have the images coded so that if the advertisement is clicked then it will go to the website for that advertisement. What I need is for the

What I need is to add the advertisement click to the advertisementcounter table: When the visitor clicks the advertisement it adds the adID to the advertisement counter.adcountAdID. Is it possible to do this with DataAssist?

Here is how I currently have it coded.

<form id="TopAdCounterForm">
<a href="<?php echo($rsTopAd->getColumnVal("adLink")); ?>" target="<?php echo($rsTopAd->getColumnVal("adTarget")); ?>"><img src="advertisments/<?php echo($rsTopAd->getColumnVal("adImage")); ?>" alt="<?php echo($rsTopAd->getColumnVal("adName")); ?>"/></a>
</form>

Thanks for any suggestions or examples.

Yes. Instead of linking directly to the page, link to a page on your site and pass in the id of the ad that was clicked. Then on that page you can increment the clicks column in the database before redirecting to the actual url.

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;&#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>

Use:
<?php $link = ($rsAdvertisment->getColumnVal("adLink",false)); ?>

It automatically add cross site scripting protection by encoding values from the database. Adding the false at the end tells it to not encode the characters.

Perfect thanks.