I have a site with a mysql database that clients log into and pull out necessary information.
As of now I currently store different actions the client performs in separate tables, (logging in, downloading files, uploading files, etc...).
What I want to be able to do is display a nice little history for them when they log in so they can see what types of actions have been performed on their account. (some clients have multiple users that login under one client name, they want to all be able to see the overall history of what is happening and when).
My first thought was to query the tables individually, then perform the merge and manipulate the data in php based on the times things happened.
That seems incredibly inefficient, so I am asking if people have any better ideas or if I can join the data in one single query and order by the dates?
I am not to good with mysql joins, I only user inner joins, so any help on maybe how I can make this function more efficient would be great. Thanks.
