PHP Link Click counter

I want to write simple counter for links/tags. So I have tags and random displayed them to the website

$zmienna = "SELECT name, link FROM tag_content ORDE开发者_如何学CR BY RAND() LIMIT 4";
$result2 = mysql_query($zmienna);
echo $result2;
while($row=mysql_fetch_array($result2)){
    echo "<a href='http://www.simplelink.xx/tag/".$row['link']."'>".$row['name']."</a><br>";
}

And now I want to count how many users clicked tags. I created another row named "wys" and tried to write SQL stuff

$wtf = "UPDATE tag_content SET wys=wys+1 WHERE id=2";
$result3=mysql_query($wtf);

As u can see it only works for tag id = 2. And now the problem: how to make it work for all tags?

For example: I have 4 tags with different id. How to make counter "read" the actual clicked tag and make it add "1" to the "wys"?

Thx for help and let me know if u need more information (like code etc.)

As the link field is unique, you can simply use it as an identifier instead of id.

$wtf = "UPDATE tag_content SET wys=wys+1 WHERE link='".$something."";

where $something is a last part of page URL (you should parse it). Of course you also need to check this variable before you use it, because you got it from client side and it could have code for SQL-injection.

You need a way to get the id of all links. Either provide it as a query parameter for the link, or use parse out the name and url from the clicked link and make a relevant SELECT to get the id to loop over.

Use jquery :eq() selector to find out the exact link and then make an ajax request for updating the count