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

[BarneyJoe]

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.

[BarneyJoe]

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.