Clicks Counter - With PHP + MySQL

<?
$host = 'localhost';
$user = 'root';
$pass = '';
$db = 'links';
mysql_connect($host,$user,$pass) or die (mysql_error()); // try to connect to database
mysql_select_db($db); // try to select the database with the link details

if(!$id)
exit; // if the link was not specified, stop runing

$id = stripslashes($id); // for security reasons

$linkquery = mysql_query("SELECT * FROM links WHERE id=$id LIMIT 1;"); // look for the specified link
$link = mysql_fetch_array($linkquery);

if(!$link)
die("The specified ID does not exists!");

// if the ID exists in the database, start the count process

$day = date("d");
$month = date("m");
$year = date("y");
$date = "$day/$month/$year";

$ip = $_SERVER["REMOTE_ADDR"];
$query = mysql_query("SELECT * FROM links_info WHERE ip='$ip';");
$lookvisitorsip = mysql_fetch_array($query);
if(!$lookvisitorsip) // if the visitor's ip isn't already in the database add one more click
mysql_query("UPDATE links SET clicks=(clicks+1) WHERE id=$id;"); // add 1 click to the specified id
// if you just want to count clicks, without get members info delete this next line
mysql_query("INSERT INTO links_info (id,ip,date) VALUES ($id,'$ip','$date');") or die(mysql_error()); // save the area which your visitor went, their IP and the date when they visit it
header("Location: $link[ref]"); // redirect to the page
?>

<?
$host = 'localhost';
$user = 'root';
$pass = '';
$db = 'links';
mysql_connect($host,$user,$pass) or die (mysql_error()); // try to connect to database
mysql_select_db($db); // try to select the database with the link details
?>
More visited:<br>
<?
$lquery = mysql_query("SELECT * FROM links LIMIT 10;"); // you can change this LIMIT 10 for any other limit u want
$x = 1;

while($link = mysql_fetch_array($lquery)){
?>
<?=$x?>°: <a href="link.php?id=<?=$link[id]?>"><?=$link[title]?></a> Cliks: <?=$link[clicks]?><br>
<?
$x++; // increase $x
}
?>