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:[EMAIL PROTECTED]
> Sent: 14 June 2004 09:25
> To: [EMAIL PROTECTED]
> 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
> 
> 
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to