Id aantal keer geladen..

CREATE TABLE linken(
  id INT auto_increment NOT NULL,
  link_naam VARCHAR(100) NOT NULL,
  PRIMARY KEY(id)
);

CREATE TABLE linken(
  id INT auto_increment NOT NULL,
  link_naam VARCHAR(100) NOT NULL,
  PRIMARY KEY(id)
);

<?php
if(isSet($_GET['pagina'])){
  $pagina = addslashes($_GET['pagina']);
  $query = "INSERT into 
         linken 
         (link_id) 
         VALUES('". $pagina ."')";
  MySQL_query($query) or die(MySQL_error());
}
?>

<?php
if(isSet($_GET['pagina'])){
  $pagina = addslashes($_GET['pagina']);
  $query = "INSERT into 
         linken 
         (link_id) 
         VALUES('". $pagina ."')";
  MySQL_query($query) or die(MySQL_error());
}
?>

<?php
$query = MySQL_query("SELECT * FROM linken");
echo "<table>";
while($obj = MySQL_fetch_object($query)){
   echo "<tr>";
     echo "<td><a href='". $_SERVER['PHP_SELF'] ."?link=". $obj->link_id ."'>". $obj->link_id ."</a></td>";
   echo "</tr>";
}
echo "<table>";

if(isSet($_GET['link'])){
   $query2 = MySQL_query("SELECT count(id) FROM linken WHERE link_id = '". addslashes($_GET['link']) ."'");
   $res = MySQL_result($query2, 0);
   echo addslashes($_GET['link']) ." heeft ". $res ." hits gehad";
}
?>

<?php
$query = MySQL_query("SELECT * FROM linken");
echo "<table>";
while($obj = MySQL_fetch_object($query)){
   echo "<tr>";
     echo "<td><a href='". $_SERVER['PHP_SELF'] ."?link=". $obj->link_id ."'>". $obj->link_id ."</a></td>";
   echo "</tr>";
}
echo "<table>";
 
if(isSet($_GET['link'])){
   $query2 = MySQL_query("SELECT count(id) FROM linken WHERE link_id = '". addslashes($_GET['link']) ."'");
   $res = MySQL_result($query2, 0);
   echo addslashes($_GET['link']) ." heeft ". $res ." hits gehad";
}
?>