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