MY hit counter :
<html>
<head>
</head>
<body>
<?php
$db_name = "kascgam_csconnectcounter"; // database name
$db = mysql_connect("localhost", "kascgam_admin", "joemks");
mysql_select_db($db_name,$db);
if(!$db) {
echo "Unable to connect to database: " . mysql_error();
exit;
}
if(!mysql_select_db($db_name)) {
echo "Unable to select database: " . mysql_error();
exit;
}
$page = $_SERVER['PHP_SELF'];
$query = "SELECT * FROM connectcounter WHERE page='$page'";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($result);
if(is_array($row)) {
mysql_query("UPDATE connectcounter SET counter=counter+1 WHERE page = '$page'") or die(mysql_error());
}
else {
mysql_query("INSERT INTO connectcounter VALUES ('$page', 1)") or die(mysql_error());
}
$query = "SELECT counter FROM connectcounter WHERE page = '$page'";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($result);
$count = $row["counter"];
echo "This page has been visited $count times";
echo "db= $db db_name= $db_name page= $page query= $query result= $result row= $row count= $count";
mysql_close($db);
?>
</body>
</html>
Theres no errors.. But the $count var isnt displaying anything.
