Re: FormatDateTime Revisited

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>
.

Relevant Pages

  • Re: Best way to install a hardrive
    ... >> Isn't that a bit Janet and John for anyone who posts here? ... Prev by Date: ...
    (uk.comp.homebuilt)
  • Re: Im famous!
    ... >> too pleased with John. ... >where you live and beat you up" posts that I get is generally around zero). ... Prev by Date: ...
    (uk.media.tv.misc)
  • Re: NTL do the timewarp again
    ... On Mon, 16 Jan 2006 20:50:16 GMT, John the R-T commented ... > Those four posts have been coming up regularly. ... Well over two and a half full years' statistics now available. ... Prev by Date: ...
    (uk.people.silversurfers)
  • Re: USA number one? Think again...
    ... I posted statistics. ... Read my next three posts. ... John ... Prev by Date: ...
    (alt.guitar.amps)
  • Re: Gun registration = confiscation, Canadian style...
    ... >>> John, why do you keep talking to this fucking idiot? ... I've hardly replied to any of his posts. ... >> who are more in need of this admonishment. ... Prev by Date: ...
    (misc.fitness.weights)