i'm trying to figure out a simple way to count the number of times a game has been played on my site. each game and all of it's details are in a table "games" and each game has it's own row.....so is there a way i could figure out how many times that row or a field in that row has been queried? if you've got a better idea on how to do this just tell me!! thanks!!
Best thing I could think of is to create a table for counters. Two fields (game_name, hits). In your code, everytime, you want to make a count, just to an update statement.
If you're on ms sql, oracle and (i think) postgre you can set up triggers to do things like this.
Yeah, all 3 of those support triggers, but unfortunately, MySQL is behind the curve still
