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! Link to comment https://forums.phpfreaks.com/topic/279924-check-last-mysql-update/ Share on other sites More sharing options...
Psycho Posted July 6, 2013 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. 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! Link to comment https://forums.phpfreaks.com/topic/279924-check-last-mysql-update/#findComment-1439726 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.