[RESOLVED] mysql time remaining

[h3r0]

Hello,

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?

[scragar]

try TIMEDIF and CURTIME

[h3r0]

It is returning null.

[scragar]

TIMEDIFF() returns expr1 – expr2 expressed as a time value. expr1 and expr2 are time or date-and-time expressions, but both must be of the same type.

what format is your end date?

use NOW() for date/time, and CURTIME for time.