Just a function to change the format of a mysql date to the one you want to.
function setDate($L_date,$L_dateFormat="dd-mm-yyyy"){//sets a date in a format
if(strlen($L_date)>0){
$L_arrTemp = split(" ",$L_date);
$L_strDate = $L_arrTemp[0]; // 2007-07-21 year month day
$L_arrDate = split("-",$L_strDate);// split date
$L_strYear = $L_arrDate[0];
$L_strMonth = $L_arrDate[1];
$L_strDay = $L_arrDate[2];
if($L_dateFormat == 'yyyy-mm-dd'){//default
return $L_arrTemp[0];
}
elseif($L_dateFormat == "dd-mm-yyyy"){//day month year
$returnDate = $L_strDay."-".$L_strMonth."-".$L_strYear;
return $returnDate;
}
elseif($L_dateFormat == "mm-dd-yyyy"){//month day year
$returnDate = $L_strMonth."-".$L_strDay."-".$L_strYear;
return $returnDate;
}
}
else return false;
}