table Update date

[kemper]

I want to include a code that states the date and time that a specific table has been updated.  I see that each table has the following logged: Creation Cate, Last Updated, and Last Checked.

 

How can I do this?

[cmgmyr]

Use NOW()

 

$update = "UPDATE your_table SET something = 'something', last_update = NOW() WHERE userid = $userid";

[kemper]

I do not understand.  This looks like it would update, not echo the date.

[cmgmyr]

Sorry, read too fast. How is the date entered into the database?

[Barand]

... and how do you want it displayed?

[kemper]

I would like to post as:

Results last updated:

Date, Time (Specific)

 

And, the table properties show (in phpMYADMIN):

Last update  Oct 22, 2007 at 04:23 PM