in mysql i have used datetime format which saves the time like 2010-11-08 08:57:31 and using php i want to calculate the difference by retrieving the date from the mysql calculating the difference from the entered date and current date and check how many days havebeen calculated. please reply as soon as possible.......