How to add no of clicks in database ?

[linux1880]

Hi all, i am creating a custom blog for practise, how do we add no of clicks in database  to that  topics visitors clicks. I have added 'clicks' field in table 'blog_posts'. Now how to add and increment value by 1 when visitors visits that topic ?

[Yesideez]

In the script that displays the topic have something like this:

mysql_query("UPDATE topic SET click=click+1 WHERE topicid=".$topicid);