Hey
I want the next script to count how many times someone clicked a link, and than go on to the actual file. It returns the next error, can someone tell me whats wrong:
<?
include("dbinfo.php");
$artiestid=$HTTP_GET_VARS['artiestid'];
$conn = mysql_connect( $dbhost, $dbuser, $dbpass );
mysql_select_db($dbname);
$query1="select * from artiesten where id=$artiestid";
$result=mysql_query($query1);
$url="artiesten.php?artiestid=$artiestid";
$hitcount=mysql_result($result,0,"hitcount");
++$hitcount;
$query2 = "update artiesten set hitcount='$hitcount'
where id='$artiestid'";
mysql_query($query2);
Header("Location: artiesten.php?artiestid=$artiestid");
exit;
?>
Thanx