I'm trying to calculate the time remaining left on an "auction". This is the code I have:
SELECT DATEDIFF(CURDATE(), endtime) AS timeleft FROM `auctions` WHERE `id` = '".$id."'
However, it only pulls the days. How can I get it to pull the seconds as well?