::Help:: on hyperlink click update Field in mySQL ? ? ?

[jkt182]

• I have a row that is queried from mySQL.
• A value from one of the feilds is taken and +1 is added to that var.
• When a hyperlink is clicked I need to take that variable and update a
  field called "clicks"

How would I go about doing this. This is my first PHP/mySQL script.

[Toby]

I would add a variable to the hyperlink to make sure only the clicks from that hyperlink are counted, and do the actual counting on the target page:

The link:

<a href="http://www.yourdomain.com/yourpage.html?referrer=source1">

The code for the target page:

<?
if ($referrer == "source1"):

  $query = "UPDATE yourtable SET clicks = clicks+1";

  $result = mysql_query($query);

endif;
?>

... or similiar. This will count multiple clicks from the same IP, though...

HTH

Toby