capturing if content has been changed (how?)

[ceci]

hi.

 

this is another general question.

 

I need to know if content has been changed or updated.

 

Scenario: there is a Submitter and a Reviewer.

Submitter submits articles for review.

Reviewer reviews article and suggests changes before being accepted.

Submitter makes the changes and resubmits back to Reviewer.

 

I want to show the Reviewer that the suggested changes has been completed by the Submitter. How can I do this? Store the content in two separate tables and count the words on each mysql table?

 

I really have no idea how I can do this effectively.

 

thanks.

[litebearer]

rough idea

 

field in that article table called 'article_status'

has, oh say, 4 possible values 1, 2, 3 or 4

if 1 it has not been reviewed

if 2 it has been reviewed with suggested changes

if 3 changes have been submitted

if 4 article approved

 

any article with status=1 would show for reviewer to review if he reviews and suggests changes status to 2

 

etc etc