RE: [PHP-DB] auto update mysql table with the current date & time
| From: | Sunmaia | Date: | Mon, 14 Jun 2004 08:47:19 +0000 |
| Subject: | RE: [PHP-DB] auto update mysql table with the current date & time | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34777@lists.php.net to get a copy of this message | ||
Hi
if you change the field type to TIMESTAMP mysql will do it for you
http://dev.mysql.com/doc/mysql/en/DATETIME.html
Peter
> -----Original Message-----
> From: Gawie Marais [mailto:gmlists@gam.co.za]
> Sent: 14 June 2004 09:25
> To: php-db@lists.php.net
> Subject: [PHP-DB] auto update mysql table with the current date & time
>
>
> hi guys,
>
> me again ! i need to update a record in a mysql table. now i have
> defined a
> datetime field when a record is modified... i want to 'auto update' that
> field whenever a record is modified... what would the php script be for
> something like that... ?
>
>
> thanx,
>
> gawie.
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> Email has been scanned for viruses and SPAM by Trader Mailmanager
> www.trader.uk.com
>
>
>