Need to increment clicks counter

Hi Ron,

No problem. There are a few ways of doing this. I think the easiest way would be to first send them along to a intermediate page (something like redirectPage.php). You would append the record number of the record you want to send them to to the end of the url.

In this page, you would first retrieve the record,

EXAMPLE:

$link = mysql_get("links", intval(@$_REQUEST['recordNum']));

You can then increment your counter using the incrementCountField function:

EXAMPLE:
incrementCounterField('links', 'clicks', $link['num']);

Finally, you can redirect the user to their destination link:

EXAMPLE:

redirectBrowserToURL($link['url']);
exit;

The user will probably not even notice they were redirected.

Hope this helps get you started.

Thanks so much for you quick response. Although the example you gave me did not work as is, I got enough of an understanding of what needed to happen to get it to work another way. Code for clickCount.php:
---------------------------------------------------------
<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
require_once "/hsphere/local/home/rconring/conring.com/cmsAdmin/lib/viewer_functions.php";
list($linkRecords, $linksMetaData) = getRecords(array(
'tableName' => 'links',
'loadUploads' => '0',
'allowSearch' => '0',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$linkRecord = @$linkRecords[0];

// $link = mysql_get("links", intval(@$_REQUEST['recordNum']));
incrementCounterField('links', 'clicks', $linkRecord['num']);
redirectBrowserToURL($linkRecord['url']);
exit
?>
----------------------------------------------------
I kept getting an error on the mysql_get line so I got the record as I would on a detail page. Can you tell me why I got the error and if any, what disadvantage my method has? Error was unexpected ";" in line ...... and I could not tell why.

Hi Ron,

The error was that I was missing a parentheses in my code (I've edited my previous post with the fix.).

It should have looked like this:

$link = mysql_get("links", intval(@$_REQUEST['recordNum']));

Note that this particular example assumes you have a variable in the URL called "recordNum".

There isn't a problem with the approach you took, as they're basically the same. I find that using mysql_get() or mysql_select when I don't need to retrieve uploads and pseudo fields keeps the code a little cleaner, but this is more of a styling choice than anything.

Glad everything is working now.

Thanks for your reply, Jason. I finally spotted the error and corrected it and now it works as it should.

You guys rock! Thanks again