Why does my article tracker update twice?

[shanks73]

Hello,

I have an article tracker that increments the number of hits an article receives as follows

<?php
// Open a database connection (Update these with your own DB server info)
mysql_pconnect($_SESSION['MYSQL_SERVER1'],$_SESSION['MYSQL_LOGIN1'],$_SESSION['MYSQL_PASS1'])
                   or die("Unable to connect to SQL server");
    mysql_select_db($_SESSION['MYSQL_DB1']) or die("Unable to select database");



$SQLII = "update articles set hits = hits + 1 where url = '".$_SERVER['REQUEST_URI']."'";
    $result = mysql_query($SQLII) or die("Invalid query (login): " . mysql_error());
	echo "<br>SQL STATEMENT:<br>".$SQLII."<br><br>";
?>

The tracker works fine if I view the page opened in my browser. However, if I select the page by clicking a link the "Hits" column increments twice. Any suggestions?

Regards,

Tom

[leatherback]

Is it possible that you have this code included twice in the page, or do you do a refresh somewhere on your page?

[shanks73]

Thanks for your reply leatherback. I have used an include once in my article file. I can't see anything that would refresh the page. I think I may try and use a javascript onclick command on each link to update the hits per article.

Thanks

Tom