List:General Discussion« Previous MessageNext Message »
From:Dan V Date:June 10 2004 11:28am
Subject:RE: How do you display last modified date
View as plain text  
I see the type "timestamp". Should I leave value, attributes...blank. Do I
just query this field and format as need via DATE()?

Thanks for the heads up.
Take care.
-----Original Message-----
From: Paul McNeil [mailto:paulie@stripped] 
Sent: Thursday, June 10, 2004 7:20 AM
To: MySQL General
Subject: Last Modified

If your table contains a timestamp field, it will update each time the row
is altered.  Otherwise I don't think it's possible.

You Wrote ---------
Hello I am using PHP, MySQL. How would I query MySQL to display the last
time a table was last modified/changed/or updated. For example I have a user
that updates a stats page via the web, and I would like it to say (Current
up to "The last date the stats table was modified"). Thanks for your help,
I've been looking online as well but thought this may be quicker. Take care.
Thanks again.

God Bless

Paul C. McNeil
Developer in Java, MS-SQL, MySQL, and web technologies.















GOD BLESS AMERICA!
To God Be The Glory!


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
Last ModifiedPaul McNeil10 Jun
  • RE: How do you display last modified dateDan V10 Jun
  • Re: Last ModifiedMartijn Tonies10 Jun
    • Re: Last ModifiedAlec.Cawley10 Jun
  • Re: Last ModifiedCarsten R. Dreesbach10 Jun
Re: Last ModifiedMartijn Tonies10 Jun
  • Re: Last ModifiedAlec.Cawley10 Jun
  • Re: Last ModifiedEgor Egorov11 Jun