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? Quote Link to comment 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. Quote Link to comment 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.