Storing what links a user has visited

Hi again guys!

OK, going to try and explain myself as best as possible here. Basically, I am developing my companys intranet, and have come up with an idea to create a list of links based on what features user visit most often. For example, if every day someone fills in there timesheet, that will be top of the list, if every week they fill in an expense claim form, that will be second, and every month they fill in a mileage claim form, that will be third.

Now, as far as I can figure out it will require a combination of PHP and MySQL, and all I can think is to create a table storing the user id and a column for every possible feature that increments by 1 every time the user accesses it. However, I’m also thinking that there is an easier way to do this, but can’t think of anything.

If anyone can at least put me on the right track I will be really grateful, as I’m bound to get some kudos for it:rich:

Thanks people!