/*
	Calculate unixtime from a MySQL DATETIME
*/

function unixtime_from_mysql($mysql_date) {

	if($mysql_date) {
		list( $date, $time ) = split( " " , $mysql_date );
		list( $year, $month, $day ) = split( "-" , $date );
		list( $hour, $minute, $second ) = split( ":" , $time);
		$unixtime = mktime( $hour , $minute , $second , $month , $day , $year );
		return $unixtime;
	} else {
		return 0;
	}

}

/*
	Calculate a MySQL format date from unixtime
*/

function mysql_from_unixtime($unixtime) {
	if($unixtime) {
		return date("Y-m-d H:i:s",$unixtime);
	} else {
		return "0000-00-00 00:00:00";
	} 

}