RE: date problem in MySQL DB

["brett king" <brett@xxxxxxxxxxxxx>]

Hi Angelo

Yes you will have to reformat and he is something that may help you.
Hope it does

	function dateCheckMysql ($date) {

		list($dateDay, $dateMonth, $dateYear) = explode("/", $date);
		if ((is_numeric($dateDay)) && (is_numeric($dateMonth)) &&
(is_numeric($dateYear))) {

			if (!checkdate($dateMonth, $dateDay, $dateYear)) {
				return false;
			} else {

				return($dateYear."/".$dateMonth."/".$dateDay);
			}
		} else {

			return false;
		}
	}

	function dateCheckForm($date) {

		list($dateYear, $dateMonth, $dateDay) = explode("-", $date);

		if ((is_numeric($dateDay)) && (is_numeric($dateMonth)) &&
(is_numeric($dateYear))) {

  			return($dateDay."/".$dateMonth."/".$dateYear);
		} else {
			return false;
		}
	}

Many Thanks
Brett

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php