Recent Pages Viewed Tracker

[ptrcklgrs]

I'm making a database system for a company that keeps track of there 1000+ Customers. Everything fine and works great.

 

The asked me for an extra feature which is a system that keeps track of the 10 recent customer info pages that they have viewed. They say it will make it a lot easier for them to find there customers because they only deal with up to 10 at a time. 

 

I can think of 2 ways to do this.

First is they work from the same computer all the time so using cookies is an option.

Second is to store it in a field in a mysql table under there profile.

 

I'm not sure which one would be the most efficient or if there is a reason against using one.

Or if there is a secret Option "C" that i'm not aware of.

 

Any help or thoughts on the topic would be great.

Thanks

[p2grace]

Does the system require the customer to login?

[ptrcklgrs]

Yes it does. Each person has there own active Session.

[laffin]

now topic said, keeping track of pages, yet u describe a last 10 users.

 

so question is are u tracking users or page views.

[p2grace]

Sounds to me like you want to track a given users activity correct?

[ptrcklgrs]

Ok let me try to explain again, re-reading my post i realized i did not explain this well at all.

 

This program is for Sales men that are spread out across the country. They look up the customers history before paying them a visit.

 

When the Sales Men log on and go in to a main/search page that organizes customers accounts different ways. I.E. Name, Location, Last time they were visited by a sales man, what they buy and other things.....

 

When they log on and go to the search page they would like a "Hot List" of the last 10 customers they themselves have clicked on rather then having to search for them through the list again. They want this because they look up the same customer over and over again when they go to see them.

 

This is a non-necessity thing and it will probably save them a total of maybe 5 min a year, however they want it and are willing to pay for it so why not.

 

Thanks

[p2grace]

Create a table that tracks sales users activity.  Each time a sales person views a customers information record it in the table.  Then create a navigation box that queries that table to show the 5 latest entries.  Should be pretty quick and painless.