How do you display last modified date

2004-06-10 Thread Daniel Venturini
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,

RE: How do you display last modified date

2004-06-10 Thread Dan V
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:[EMAIL PROTECTED] Sent: Thursday, June 10, 2004 7:20 AM To: MySQL General

Re: How do you display last modified date

2004-06-10 Thread Egor Egorov
Daniel Venturini [EMAIL PROTECTED] 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

Re: How do you display last modified date

2004-06-10 Thread mysql1
On 10 Jun 2004 at 7:02, Daniel Venturini 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