last updated date from MySql database

2006-12-12 Thread Will Swain
Hi, I want to show the last updated date on a site. Rather than do this manually, is there a way I can get this programatically for a table in mySQL? Also, is it possible with an MSACCESS database? Part of the site runs on an old access database, so rather than update it all (they don't want

RE: last updated date from MySql database

2006-12-12 Thread Will Swain
Resending this. I had a major mailserver problem this am and lost a few mails, so just incase I missed any replies! -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED] Sent: 12 December 2006 09:55 To: CF-Talk Subject: last updated date from MySql

Re: last updated date from MySql database

2006-12-12 Thread Jacob Munson
I want to show the last updated date on a site. Rather than do this manually, is there a way I can get this programatically for a table in mySQL? I guess I'm confused. Do you want to show the last time a DB table was updated, or just show the latest record using a time stamp field? If it's

RE: last updated date from MySql database

2006-12-12 Thread Will Swain
PROTECTED] Sent: 12 December 2006 14:43 To: CF-Talk Subject: Re: last updated date from MySql database I want to show the last updated date on a site. Rather than do this manually, is there a way I can get this programatically for a table in mySQL? I guess I'm confused. Do you want to show

Re: last updated date from MySql database

2006-12-12 Thread Jacob Munson
I just want to check the last time a table was updated and display that time on the homepage. I know I can write some code that marks the time of an update or insert into the database and use that, but I noticed that mySQL tables have an update time on them, and wondered if I can shortcut and

RE: last updated date from MySql database

2006-12-12 Thread Will Swain
Thanks Jacob. Thought it might be something standard that I was unaware of. I'll go read the mySQL docs. Will -Original Message- From: Jacob Munson [mailto:[EMAIL PROTECTED] Sent: 12 December 2006 17:49 To: CF-Talk Subject: Re: last updated date from MySql database I