[RESOLVED] Update and Insert

[MystedVeil]

I have several tables containing content submitted/updated by various members. What i am wondering is, if i want to keep a record of who is changing what persay would I simply do it like this

if(isset($_POST['submit'])){// handle the form
// Connect to the database.
require_once('../include/connect.php'); 
        // Query the database.    


// The insert condition.
  	$row['ID']= $_POST['ID'];
$query = "UPDATE table SET  field1='$field1' WHERE  ID = '$ID' ";

        $result = @mysql_query ($query); // Run the query.

        if ($result) { // If it ran OK.


$query2 = "INSERT INTO UpdateList (ID, User) values('$ID', '$User') ";  


        $result2 = @mysql_query ($query2); // Run the query.

        if ($result2) { // If it ran OK.

so on and so forth?

[YAOMK]

I usually add a "lastUpdated" field to my "userProfile" table so that I know when the information was last updated. You on the other hand, seem to require detailed information on what was updated, you could do this by creating an update table that keeps track of the user and what he/she updated.

Table Update
User_id | Name | Last | Age | etc......
TIMESTAMP TIMESTAMP TIMESTAMP TIMESTAMP

[MystedVeil]

I do have a seperate table to keep up with this information but as many authorized members can update all the articles I wanted it this way. If the content table is updated I want to store a record of the update. Now say another user updates this information, I want it to record that as well.

I tested out my above idea of how it should go and it worked, yay! does this mean i am actually learning?