the problem is DATEDIFF command available in MySQL ver 4.1.1 above
In MySQL versions < 4.1.1 you can use the following construct: SELECT TO_DAYS('2006-10-06') - TO_DAYS('2006-10-05') -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php