What I want is a counter that record the number of unique hits and uses PHP and MySQL...

Anyone be able to help ??

Thanks

-James

I think i might be able to help, just hang on...
Sorry cant help you, i cant figure it out, still using your ebook, its ace lol.


Mik

http://www.hotscripts.com/PHP/Script...ers/index.html

But they are easy enough to make. Simple counter:
database has id page and count fields

then add this PHP code to each page you want counted:

PHP Code:

<?
$page=$_SERVER['REQUEST_URI'];
$exists="SELECT id, count FROM counters WHERE page='".$page."'";
$result=mysql_query($exists);
$num=mysql_num_rows($result);
if($num==0)
{
$query="INSERT INTO counters VALUES ('','".$page."','0')";
}
else
{
$id=mysql_result($result, 0, "id");
$count=mysql_result($result, 0, "count");
$count++;
$query="UPDATE counters SET count='".$count."' WHERE id='".$id."'";
}
mysql_query($query);
?>

Thats a very basic script. You can do a lot more with some work. There's a great article on http://www.phpbuilder.com/columns/ti...1.php3?aid=166