MySQL Structure Help

Discussion in 'MySQL' started by Dehisce, Nov 25, 2007.

0
  1. #1
    Re: Coz.be

    At the moment the site tracks hits & unique hits. I am wanting to update the site a little bit so it provides statistics going back up to 12 months. I am not sure how I would structure the MySQL database for this?

    At the moment I am just using one table called statistics with these fields:
    Entry ID
    URL
    Total Hits
    Unique Hits

    Any ideas?
     
    Dehisce, Nov 25, 2007 IP
  2. webavt

    webavt Peon

    Messages:
    45
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Add a date field in there..?
     
    webavt, Dec 9, 2007 IP