Ok, I put it all in the same file. Still doesn't work.
<?php
////////// MySQL Database Information ////////////
$dbservertype='mySQL';
$servername='localhost';
$dbusername='**********';
$dbpassword='**********';
$dbname='**********';
////////// End Database Information ////////
//// Other Information ///////
function ConnectToDB($servername,$dbname,$dbuser,$dbpassword)
{
global $dblink;
$dblink = mysql_connect ("$servername","$dbuser","$dbpassword")or die("Couldn't connect to the database.");
mysql_select_db("$dbname",$dblink) or die ("Could not select Database".mysql_error());
}
ConnectToDB($servername,$dbname,$dbusername,$dbpassword);
$VisitorIP=$_SERVER['REMOTE_ADDR'];
$result = mysql_query("SELECT Hits FROM Visitors WHERE IP = '$VisitorIP'");
$num_rows = mysql_num_rows($result);
if($num_rows){
while ($row = mysql_fetch_array($result, MYSQL_NUM)) { $numHits = $row[0]; }
mysql_free_result($result);
$newHits = $numHits + 1;
mysql_query("UPDATE Visitors SET Hits = '$newHits' WHERE IP = '$VisitorIP' AND Hits = '$numHits'");
}
else {
/*echo "Unable to match IP";*/
mysql_query("INSERT INTO Visitors (IP, Hits, Date, Time) VALUES ('$VisitorIP', '1', CURDATE(), CURTIME())");
$allrows = mysql_query("SELECT * FROM Visitors");
$TotalVisitors = mysql_num_rows($allrows);
mysql_free_result($allrows);
if ($TotalVisitors == '7') {
header("Location: http://www.domain.com/winner.html"); /* Redirect browser */
exit;
}
}
?>
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<body>
Why doesn't this work
</body>
</html>