greggustin Posted September 2, 2006 Share Posted September 2, 2006 small MySQL DB => only three rows (ID, GroupID, title, MSG, etc)The Group ID is uniqueI have a php file that prints a table based on the fieldsthis php file checks on a time schedule to see if the ID has changed(no change - no display // new ID = new display)easy when I made a NEW post (Insert) to table (ie ID was auto-increment)what "trick" can I do when doing Update? without making the user place a NEW value somewhere? Link to comment https://forums.phpfreaks.com/topic/19492-how-to-test-db-if-it-has-been-updated/ Share on other sites More sharing options...
AndyB Posted September 2, 2006 Share Posted September 2, 2006 At time1, get the highest id value ( ORDER by id DESC limit 1) and write it to a text file.At time2, get the highest id value and compare it with the value in the text file. If they match, then no display. If they don't then display AND write a new 'highest' value to the text file. Link to comment https://forums.phpfreaks.com/topic/19492-how-to-test-db-if-it-has-been-updated/#findComment-84736 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.