shlocko Posted July 6, 2013 Share Posted July 6, 2013 I am working on a website, where you can have accounts and status'. I want to create a "recent status updates" area but I need a little help. Is there a way to like, check recent updates to a mysql database? like check how recently under the table member the area "status" has been updated? if anyone could point in the right direction for this, it would be quite helpful. And if you maybe need more info to help me, let me know. Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/279924-check-last-mysql-update/ Share on other sites More sharing options...
Solution Psycho Posted July 6, 2013 Solution Share Posted July 6, 2013 If you want to get a result of records based upon the time that a field was updated you need to add another field to track those changes. So, if you want to pull records based upon when 'status' field was updated in the members table, then you should add a new field, e.g. 'status_update', and set its value whenever status is changed. Quote Link to comment https://forums.phpfreaks.com/topic/279924-check-last-mysql-update/#findComment-1439725 Share on other sites More sharing options...
shlocko Posted July 6, 2013 Author Share Posted July 6, 2013 Alright, I will do that. Thanks for all your help! Quote Link to comment https://forums.phpfreaks.com/topic/279924-check-last-mysql-update/#findComment-1439726 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.