Posted by Pedro Graca on 09/28/25 11:37

John K top-posted (previous posts snipped):
> I have the date and time fields separate at the moment. this is what
> I'm trying to do...
>
>
> $dateMerge = $_POST['month']. " " . $_POST['day'] . ", " .
> $_POST['year'] ;
> $timeMerge = $_POST['Time_Hour'] . ":" . $_POST['Time_Minute'] .
> $_POST['Time_AMPM'];
>
> if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "gigAdd"))
> {
> $insertSQL = sprintf("INSERT INTO tbl_gigs (fld_gig_Title,
> fld_gig_Date, fld_gig_Time, fld_gig_Comments) VALUES (%s, %s, %s, %s)",
> GetSQLValueString($_POST['gigTitle'], "text"),
> date("Y-m-d", ($dateMerge)),

date("Y-m-d", mktime(0, 0, 0, $_POST['month'], $_POST['day'], $_POST['year'])),

> GetSQLValueString($timeMerge, "text"),
> GetSQLValueString($_POST['comments'], "text"));
>
> it's not working, the date is still messed up.

--
If you're posting through Google read <http://cfaj.freeshell.org/google>

[Back to original message]