mysql - php time messed up

i need help creating a count down timer in php.
the problem is that i want to store an INT in my database which is going to be seconds,
and this int is going to be added to current time to represent the future time.

now if i try to subtract the current time from future time to show how many seconds remaining, am getting wrong date.

here is my schema

mysql> desc buildings;
+-----------+-------------+------+-----+---------+----------------+
| Field     | Type        | Null | Key | Default | Extra          |
+-----------+-------------+------+-----+---------+----------------+

| id        | int(11)     | NO   | PRI | NULL    | auto_increment |
| name      | varchar(20) | YES  |     | NULL    |                |
| level     | int(2)      | YES  |     | NULL    |                |
| created   | int(11)     | NO   |     | NULL    |                |
| finished  | int(11)     | YES  |     | NULL    |                |
| player_id | int(11)     | YES  | MUL | NULL    |                |
| position  | int(2)      | YES  |     | NULL    |                |
+-----------+-------------+------+-----+---------+----------------+

and heres the code to check

//starting session;
//connecting to database;

$query = "select created, finished from buildings where id = 1";
$query = mysql_query($query) or die ("could not query 
".mysql_error() );


while($row = mysql_fetch_assoc($query))
{

$created = $row['created'];
$finished = $row['finished'];
}

$CurrentTime = time();
$status = $finished - $CurrentTime;
$realstatus = date("H:i:s",$status);


if($status > 0)
{
echo "under construction, still ".$realstatus." to finsih";
}else
{

die("construction complete");
}


//echo $created."
".$finished;


?>

any help will be greatly appreciated.

Answer

Your problem is that you are subtracting two timestamps and format the result as a date. The result is not a date, it´s an interval between two dates.

If you want to know how many hours / minutes / seconds are remaining, you just have to divide your result $status through 3600 / 60 / 1 (divide for hours and take the remainder to divide for minutes etc.).