i need time to start and show only minutes and hours only.
Please tell me the error. I am new to this..

I have provided The sql query but it unable to update the database

//auto update remaining time...
DATE_FORMAT('2003-10-03',GET_FORMAT(DATE,'EUR'))
mysql_query("UPDATE $usertable SET Rtime=(now() - Tpost) ") ;
mysql_query("UPDATE $usertable SET tcal=TIMEDIFF(now(),Tpost) ") ;
mysql_query("UPDATE $usertable SET rcal=TIMEDIFF('24:00:00',tcal) ") ;
mysql_query("UPDATE $usertable SET thr=HOUR(rcal) ") ;
mysql_query("UPDATE $usertable SET tmin=MINUTE(rcal) ") ;