> 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 just > use that data. There are a number of tables that can be updated, so I'd need > to check them all, compare the updated times and only show the most recent.
Oh, I see. I didn't know mySQL did that. I don't know how you'd access that. How are you seeing this last updated date, from the MySQL Admin? You could google around, there might be something with "show tables" you could do... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263766 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
