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 d
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
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
Subjec
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,