tatorface Posted November 21, 2007 Share Posted November 21, 2007 I have searched the interweb and haven't been able to find a suitable tutorial or premade script that could help me here. I searched the forum here and found nothing either. Maybe I haven't used the right keywords, but I don't think I'm reposting anything here. I hope someone can help me. I have a 33 column table with information that is changed by a multitude of users. I would like to keep track of the last changes made to any one row in the table. Here is what I thought of so far but believe there has to be a better way: Once a user clicks update, the update script grabs whats in the given row, either saves it to an array or temp table then writes the new info to the perm database, grabs it, compares the two against each other to figure out what changed and adds it to the "update_changes" table, ready to grab by whoever wants to see it. This seems like a round about way of doing this and I have to believe php and mysql are smarter than this. Everytime I run into a problem, I find after hours of searching that there IS a built in function that does what I need Can anyone point me in the right direction? Quote Link to comment https://forums.phpfreaks.com/topic/78268-compare-rows-after-changes-and-return-changes/ Share on other sites More sharing options...
tatorface Posted November 21, 2007 Author Share Posted November 21, 2007 bump... Quote Link to comment https://forums.phpfreaks.com/topic/78268-compare-rows-after-changes-and-return-changes/#findComment-396162 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.