jsWalter wrote: > is there a way to have mySQL auto insert the current DATE into a field when > a record is created, but when it's not updated? <http://www.mysql.com/doc/en/TIMESTAMP_pre-4.1.html> The TIMESTAMP column type provides a type that you can use to automatically mark INSERT or UPDATE operations with the current date and time. If you have multiple TIMESTAMP columns in a table, only the first one is updated automatically. HTH! -- Hassan Schroeder ----------------------------- hassan at webtuitive.com Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code.