Hi all, I'm designing a table to hold classified ads...one of the columns i want to have is date_entered...i was wondering if using a default value of NOW() is ok...my guess is that its probably both stupid and not the most sound way to do it (maybe not even possible), but i'd appreciate some advice from those who know better... thanks for any thoughts jack dempsey --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php