//reverse the order of the date from yyyy-mm-dd to dd-mm-yyyy function convert($mysql_date) { $date = $mysql_date; $month = substr($date, 5, 2); switch ($month) { case "01": $month = "Jan"; break; case "02": $month = "Feb"; break; case "03": $month = "Mar"; break; case "04": $month = "Apr"; break; case "05": $month = "May"; break; case "06": $month = "Jun"; break; case "07": $month = "Jul"; break; case "08": $month = "Aug"; break; case "09": $month = "Sep"; break; case "10": $month = "Oct"; break; case "11": $month = "Nov"; break; case "12": $month = "Dec"; break; } $new_date = substr($date, 8, 2); $new_date = $new_date . " " . $month; $new_date = $new_date . " " . substr($date, 0, 4); return $new_date; } ?> function compare($mysql_date) { $date = $mysql_date; //reverse the order of the date from yyyy-mm-dd to mm-dd-yyyy $live_date = substr($date, 5, 2); $live_date = $live_date . "-" . substr($date, 8, 2); $live_date = $live_date . "-" . substr($date, 0, 4); $d = split("-",$live_date); $date_seconds = mktime(0,0,0,$d[0],$d[1],$d[2]); #turn $date into seconds since January 1, 1970 $today = time(); #today's date in seconds since January 1, 1970 if ($today > $date_seconds) { return 1; exit(); } Else { return 0; exit(); } } ?>