Jump to content

[SOLVED] Automatically update a 'Last Updated By' field


Recommended Posts

Basically I have a main table of developments we're keeping track of, including a 'Last Updated By' field.

 

There is also a table of users so that people can log in (and hopefully somewhere along the line store the 'current user').

 

The idea is that when a development is updated the 'Last Updated By' field updates to the name of the user making the change.

 

Can someone point me in the right direction with how to achieve this...

 

Cheers.

OK - think I've figured out how to do it just using dreamweaver's log in / restrict access behaviours, and simply having a hidden field :

 

<input name="LastUpdatedBy" type="hidden" id="LastUpdatedBy" value="<?php echo $_SESSION['MM_Username'] ?> ">

 

And then inserting this into the table from the update page.

 

It's only a small local application, rather than anything major out in the wild, so it should be OK.

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.