twsowerby Posted April 15, 2008 Share Posted April 15, 2008 Hi all, Is there a function that will return the details of the last database modification that was done? Basically I have users classified based on various attributes stored against them. If a user updates their details, I need to be able to run a script which checks what was updated and then re-classifies the user. Regards, Tom Link to comment https://forums.phpfreaks.com/topic/101193-solved-returning-recent-database-changes/ Share on other sites More sharing options...
soycharliente Posted April 15, 2008 Share Posted April 15, 2008 I feel like someone asked this before and we came to the conclusion no. I may be wrong. I couldn't find anything in the search. Maybe you can put a text file on the server and update it every time a query is run. That may be a lot of changes to make, but you'll get the information that you need. Link to comment https://forums.phpfreaks.com/topic/101193-solved-returning-recent-database-changes/#findComment-517632 Share on other sites More sharing options...
twsowerby Posted April 15, 2008 Author Share Posted April 15, 2008 Awesome, I love it when I have to find a way around seemingly impossible things when I'm working to a deadline. I'll try and figure something out, but if any of you come up with any brilliant ideas then please post! Thanks, Tom Link to comment https://forums.phpfreaks.com/topic/101193-solved-returning-recent-database-changes/#findComment-517635 Share on other sites More sharing options...
craygo Posted April 15, 2008 Share Posted April 15, 2008 Probably the only way is to create another table and insert some data based on what the user has done. So if they updated their profile you can insert into the new table things like username, table_updated, fields_update, date_updated Then you can just query the one table to get back your results. not sure how detailed you want it to be. Ray Link to comment https://forums.phpfreaks.com/topic/101193-solved-returning-recent-database-changes/#findComment-517645 Share on other sites More sharing options...
sasa Posted April 15, 2008 Share Posted April 15, 2008 just include your script just after user update something Link to comment https://forums.phpfreaks.com/topic/101193-solved-returning-recent-database-changes/#findComment-517776 Share on other sites More sharing options...
twsowerby Posted April 15, 2008 Author Share Posted April 15, 2008 Hmmm and automatically run the classification script on every field each time the database is updated...yeah that seems like the easiest option actually. Thanks for your help guys. Regards, Tom Link to comment https://forums.phpfreaks.com/topic/101193-solved-returning-recent-database-changes/#findComment-517785 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.