Hit Counter

I just wrote my own hack for version 1.1.5 that keeps
track of hit counts. The problem is, everytime
I update the database field
(counter=counter+1)
It winds up incrementing in intervals of 2

55...57...59...61

I put the code in index.php3

I made sure I placed the code in after
if ($action=="showforums") {

...
...
...
$DB_site->query("UPDATE hitcounter SET counter=counter+1");
...
...

}

why is this happening?

PS

Here is how I created the DB Table

$DB_site->query("CREATE TABLE hitcounter (counter MEDIUMINT (8) UNSIGNED DEFAULT '0' not null)");

[Edited by HarryPotter on 01-19-2001 at 10:04 AM]

FUBAR'd MySQL.

well like I said before, I created a test script and in the test script, I do not have these probelms...These
probelms occur only when the code is inserted into
index.php

how about just requring your test script below the require config.php and see if that helps.

I am having this same problem kinda.

I used the weblog script.

Somehow it is loading the page twice, I put on my index page a simple script to log refering url, browser, ip etc.

Then in mysql when I check I get 2 entrys per visitor, one will show the url they came from, the second is from my site.

So I know something with global.php is causing it to load twice.

It is not in a while loop either.