If all you're looking to do is check the last time the entire table was updated, why don't you just look at the last time the .frm file (if using MyISAM tables, of course) was modified?
Thursday, June 10, 2004, 7:19:32 AM, you wrote: PM> If your table contains a timestamp field, it will update each time the row PM> is altered. Otherwise I don't think it's possible. PM> You Wrote --------- PM> Hello I am using PHP, MySQL. How would I query MySQL to display the last PM> time a table was last modified/changed/or updated. For example I have a user PM> that updates a stats page via the web, and I would like it to say (Current PM> up to "The last date the stats table was modified"). Thanks for your help, PM> I've been looking online as well but thought this may be quicker. Take care. PM> Thanks again. PM> God Bless PM> Paul C. McNeil PM> Developer in Java, MS-SQL, MySQL, and web technologies. PM> GOD BLESS AMERICA! PM> To God Be The Glory! -- Best regards, Carsten R. Dreesbach mailto:[EMAIL PROTECTED] Senior Consultant Systar, Inc. 8000 Westpark Dr Suite 450 McLean, VA 22102 USA Tel: (703) 556-8436 Fax: (703) 556-8430 Cel: (571) 213-7904 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
