What do you recommend for record created, last modified data types?
date/datetime with NOW() in insert/update queries
Or timestamp with on update and/or on create defaults
I got two timestamps in one record to work properly for created, modified.
But for modified, there is a difference between timestamp and datetime.
Timestamp removes this headache from the PHP layer, but now timestamp means
any time the record is modified while datetime leaves the ³modified²
decision to the application layer and business logic.
Cliff
_______________________________________________
New York PHP Community MySQL SIG
http://lists.nyphp.org/mailman/listinfo/mysql
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
