Person Counter Script |
||
  Gamma Cpt Goatrider Ok, so I think I've screwed myself here...I've got a script that I threw together the other day to count how many times certain people walk into a room. Think of it as one of those little silver clicky things that count people at gates, etc (see image here) - it's really just a joke script, we want to see how many times employees enter or loiter in rooms they shouldn't be in, so every time we see a person walk in, we select their name from a dropdown, click submit, and their name is entered into a mysql database row, along side a unix timestamp of the click. This is all well and good, but now that I've got unix timestamps, I want to make a report of who had the most "clicks" in any given day, but I cant figure out how to make a report using the unix timestamps...I can make it "the past 24 hours" but if someone wants to look for stats for say, May 2nd, I cant figure out a way to do that. Should I convert the timestamps to actual dates, then use regex to sort the days? Grr... By the way, this is in PHP/MySQL. --goat Replies:
|
||
| CyberArmy::Forum v0.6 Generated In 0.02061 seconds |
2008-05-15 00:56:31
2008-05-08 17:49:35
2008-05-09 22:48:43
