Code: Select all
$total = $row['hits'] + 1;
$query = "UPDATE `affiliates` SET `hits` = '$total' WHERE `id` = '$id'";
$result = mysql_query($query) or die(mysql_error());Code: Select all
$query = "UPDATE `affiliates` SET `hits` = '$total' WHERE `id` = 'id++'";
$result = mysql_query($query) or die(mysql_error());