Jump to content

how to test DB if it has been updated?


greggustin

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?

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

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.