title: Tracking how many times a user has ranked above X place in a "Weekly High Score" database
body: <p>My application has a <code>VIEW</code> of another table that displays a list of all recorded high scores for the last calendar week.  Each week, I'd like to increment a value in the rows of every user who is in the top X of this list to indicate that they've been in said top X however many weeks in the past. Since I'm only using a date filter and there's no sort of server side "event" firing off each week, I'm not sure of the most efficient way to register this information on a weekly basis.</p>
  
  <p>One way I can think of doing so is to simply run some sort of "check" every time a user logs on, and the first user to log on each calendar week shoulders the burden of telling the server to increment the top X users of last week.  While this seems a bit hokey to me, I will gladly do it with enough Internet Approval.</p>
  
  <p>The main languages I'm working with are MySQL and PHP, in case it's of relevance.</p>