[RESOLVED] Increment a field

[thewalluk]

I'm trying to create a simple logging system for the links on my site. At the moment I have a table that contains the link id, description & url. What I also want to do is add a row (count) and have it increment when someone clicks on a link.

E.g.

User clicks links > reads url from table & registers click for links > redirects the user.

Any suggestions I've used INSERT INTO and various other methods but it won't add anything to the clicks row.

If your interested here is the code:

<?php 
include('connect.php');
$Link=mysql_connect($Host,$User,$Password);
$Query = "SELECT * FROM nav_redirect WHERE section=('$section')";
$Result=mysql_db_query ($DBName, $Query, $Link);
while ($Row = mysql_fetch_array ($Result)){
print("<meta http-equiv=\"refresh\" content=\"5;URL=$Row[url]\">");}
mysql_close ($Link);
?>

Help Me

[bad76]

Hi,
are you tring with UPDATE ... SET ?

  $Link=mysql_connect($Host,$User,$Password); 
  $Query = "SELECT * FROM nav_redirect WHERE section=('$section')"; 
  $Result=mysql_db_query ($DBName, $Query, $Link); 
  if ($Row = mysql_fetch_array ($Result))
  { 
    $Query = "UPDATE nav_redirect SET clickcount=".($Row["clickcount"]+1)." WHERE section=('$section')"; 
    mysql_db_query ($DBName, $Query, $Link); 
    print("<meta http-equiv=\"refresh\" content=\"5;URL=$Row[url]\">");
  } 
mysql_close ($Link); 

i hope this help...