# Killer headache, brain no workey... :(

**URL:** <https://forum.kirupa.com/t/killer-headache-brain-no-workey/273202>\
**Category:** programming\
**Created:** [October 13, 2008, 12:08am UTC](https://forum.kirupa.com/t/killer-headache-brain-no-workey/273202 "2008-10-13T00:08:55Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![lorren\_biffin](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/lorren_biffin/32/2726_2.png) [@lorren\_biffin](https://forum.kirupa.com/u/lorren_biffin)\
**Post date:** [October 13, 2008, 12:08am UTC](https://forum.kirupa.com/t/killer-headache-brain-no-workey/273202/1 "2008-10-13T00:08:55Z")

</div>

I’m building some very simple site usage reporting into a project I’m working on. I’ve got a db table logging page hits with the following columns:

```auto

  ID
  Date
  Time
  StoreID
  Referrer
  URI
  IP
  UserAgent
  Platform

```

What’s the best method to grab daily unique visitors based on this page hit data? I’ve done this before, but like I said my brain doesn’t want to process thought through all of the hurting. ☹

Thanks in advance.