Jump to content

Archived

This topic is now archived and is closed to further replies.

greggustin

how to test DB if it has been updated?

Recommended Posts

small MySQL DB => only three rows (ID, GroupID, title, MSG, etc)
The Group ID is unique
I have a php file that prints a table based on the fields
this 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?

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.