Re: Get the ts of the last change???
| From: | Edward Marczak | Date: | Tue, 18 Jun 2002 19:47:45 +0000 |
| Subject: | Re: Get the ts of the last change??? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19866@lists.php.net to get a copy of this message | ||
On 6/17/02 5:18 AM, "Alex Elderson" alex@netflex.nl pressed the keys forming
the message:
> Hi,
>
> Is it possible to get the time of the last change of a mysql table?? in php?
Sure. Try this:
$info = mysql_fetch_array(mysql_query("show table status from dbname like
'tablename'"));
echo "Last update for tablename: ".$info["Update_time"];
Enjoy.
--
Ed Marczak
marczak@usa.net