Brett King wrote:


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

Wow, that's lots of code. I'd recommend something simpler. Like:


$mysqlDate = date('Y-m-d', strtotime($myDate));

$myDate = date('m/d/Y', strtotime($mysqlDate));

No checking involved, just one line of code.

--
paperCrane <Justin Patrin>
--
Question Everything, Reject Nothing

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



Reply via email to