Your easiest route would be to make createddate a DATETIME field and update it yourself when you insert a record. You can then make updateddate a TIMESTAMP and let MySQL set it to NOW() automatically for you by not specifying it in any of your insert or update queries. If you made them both timestamps then both fields would get updated as the record changes. Play with it some and you'll see how it behaves.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]