php time difference & mysql

[lyax]

$result = mysql_query("SELECT * FROM utopia WHERE kullaniciadi='$session->username'");
$row = mysql_fetch_assoc($result);

//Build Today     
$thour=date('H');
$tmin=date('i');
$tsec=date('s');
$tmonth=date('n');
$tday=date('d');
$tyear=date('Y');
//convert it to unix timestamp
$today=mktime(date('H'),date('i'),date('s'),date('n'),date('d'),date('Y'));
$target = mktime(date('H'),date('i')+42,date('s'),date('n'),date('d'),date('Y'));
$difference =($hedef-$today) ;
$hedef=date(strtotime( $row['timestamp'] ));


$days_left =(int) ($difference/60/60/24);
$hours_left = (int) (($difference - $days_left*60*60*24)/60/60);
$minutes_left = (int) (($difference - $days_left*60*60*24 - $hours_left*60*60)/60);	

if($row['bolge'] !== "centria" && $row['bolge'] !== "yol"){
print "<br><br>Our event will occur in $minutes_left minutes";

//$mysqldate = date( ‘Y-m-d H:i:s’, $phpdate );
//$phpdate = strtotime( $mysqldate );

$result = mysql_query("UPDATE utopia SET timestamp=FROM_UNIXTIME($target) , bolge='yol' WHERE kullaniciadi='$session->username'") 
or die(mysql_error());
}
else{


if($difference > 0) {
echo"You have to wait $minutes_left minutes.";
}
else{
}


}

This code is inserting the target date to mysql but not showing the $minutes_last variable in the page. İs it about the codes or about the date-time transfer between php and mysql ????

thanks.

[yzerman]

$today should be like this, not like you have it:

 

$today = date();

[lyax]

Nothing changes then. Ive tried many times as $today = date(); (and tried again.)

I think the problem is about server time, mysql time...or.. date types etc.

Couldnt solve it for days..

in the page nothing is displaying about time difference... blank..

[yzerman]

how are you storing the time and date in your db?

[lyax]

Storing as a DATETIME row. Tried timestamp but couldn't do that.

 

[lyax]

if it is necessary i can change the mysql row type to timestamp.. have any idea???