Thanks again Ian, its becoming a long day! My form button is set via a js file so I don't have a submit button name as such?
On my insert page I have now added Daves function above your code, 1 each for the date fields on my page. This still inserts 0000-00-00 into database rather than null and still displays 01-01-1970 on results page.
Is this because I have no submit button to reference do you think?
<?php
function i8_formatUKDateMySQL($date) {
$d = str_replace(" ","",$date);
$d = explode('/', $date);
$d = $d[2].'-'.$d[1].'-'.$d[0];
return $d;
}
?>
<?php
if (isset($_POST["doc_upload"])) { // Trigger assuming that your submit button is called BT_Add
if ($_POST['StatusActiveDate'] != '') {
$_SESSION['StatusActiveDate'] = i8_formatUKDateMySQL($_POST['StatusActiveDate']);
} else {
$_SESSION['StatusActiveDate'] = Null;
}
}
?>
<?php
if (isset($_POST["doc_upload"])) { // Trigger assuming that your submit button is called BT_Add
if ($_POST['StatusCompDate'] != '') {
$_SESSION['StatusCompDate'] = i8_formatUKDateMySQL($_POST['StatusCompDate']);
} else {
$_SESSION['StatusCompDate'] = Null;
}
}
?>
Thanks again..
