> This leads me to another question. If I have stored the date as an > epoch then is there a way using PHP and MySQL to say find all the > records that have been added this YEAR (not last 365 days)?
SELECT * FROM table WHERE YEAR(FROM_UNIXTIME(column)) = YEAR(CUR_DATE()); Benchmark each method and see which is faster... ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
