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.