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@xxxxxxxxx] > Sent: 14 June 2004 09:25 > To: php-db@xxxxxxxxxxxxx > Subject: 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
