PHP Tracker

[woody79]

Could anybody please tell me if this would work?

<?php
$page = ""; //page name here eg.home, Home, hOMe
$page = strtolower($page);
$sqllink = mysql_connect("localhost","*****","*****");
$sqldata = mysql_select_db("tracker",$sqllink);
$tmstmp = date("Y:m:d:H:i:s");
$edsssn = date("Y:m:d:H:i:s");
$user = $_SERVER['PHP_AUTH_USER'];
if(!isset($_COOKIE['tracker'])) {
	$uid = date("YmdHis").rand(0,99);
	setcookie("tracker",$uid);
	$sqlquery = "INSERT INTO reports(uid, user, timestamp, tracker,endsession)";
	$sqlquery .= "VALUES('$uid', '$user', '$tmstmp', '$page', '$edsssn')";
	mysql_query($sqlquery);
}else{
	$result = mysql_query("SELECT * FROM tracker WHERE uid='".$_COOKIE['tracker']."' AND user='".$_SERVER['PHP_AUTH_USER']."'");
	$number = mysql_num_rows($result);
	if($number == 1) {
		$i = 0;
		while($number > $i) {
			$getuid = mysql_result($result,$i,"uid");
			$getuser = mysql_result($result,$i,"user");
			$gettmstmp = mysql_result($result,$i,"timestamp");
			$gettrack = mysql_result($result,$i,"tracker");
			$getedsssn = mysql_result($result,$i,"endsession");
			$i++;
		}
		$pageupdate = $gettrack."=>".$page;
		$edsssnupdate = date("Y:m:d:H:i:s");
		$update = mysql_query("UPDATE tracker SET tracker='"$pageupdate"', endsession='"$edsssnupdate"' WHERE uid='".$_COOKIE['tracker']."' AND user='".$_SERVER['PHP_AUTH_USER']."'");
	}
}
?>