I need to make a counter that will increase by one each time its activated

Place were action takes place
$DB_site->query("UPDATE user SET mycount=mycount+1 WHERE userid=$userid");

Run Query
ALTER TABLE user ADD mycount INT (20) not null

Add in Postbit Template
$userinfo[mycount]

would the above work? :confused:
thanks

What I want is something like the points hack BUT i want the points to be added automatically when a user does something