MySQL as a Usage/stats system?

[eskantze]

This might not be the right avenue, but I have the following situation: ???

 

I created a database driven site, which displays different information depending on a user's client affiliation.  So, if you access page.php, it will display different info for company A, vs. company B or C.  However, I now have the need to track hits/visits on the site and break it down by client.

 

This won't work on a regular web stats system because I just get all the hits for page.php and don't know how to break them down further.

 

I tried a rudimentary PHP/mySQL interaction to track the hits, but I can't get it to work the way I want it to.  All I need is the number of visits per page, broken down by client.  I am open to any ideas, SQL or otherwise.

 

Thanks in advance for your help

[trq]

So, if you access page.php, it will display different info for company A, vs. company B or C.

 

How do you currently determine who is from company A, B or C?

[eskantze]

So, if you access page.php, it will display different info for company A, vs. company B or C.

 

How do you currently determine who is from company A, B or C?

 

Which information is seen is determined by a data table of users, so the table might look something like:

 

username

password

site_version

john

doe

1

Jane

doe

2

 

So, john would see version 1 and Jane would see version 2, etc.

[trq]

So, your able to identify John and Jane as being two seperate identities? All you need do is log each hit for each identity seperately. Seems simple enough to me.