Thanks guys, I ended up going back to the mysql date and time entries. I
just had to rewrite some of my php stuff to get it to work with the rest of
my files. Thanks for all the help!
Jake
----- Original Message -----
From: "Brian Ashe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 12, 2002 11:25 AM
Subject: Re: MySQL Question
> Jake,
>
> On Tuesday 12 February 2002 11:00, you said something about:
> > Yes, I'm using PHP.
> >
> > I tried this, but then it doesn't display the way I want it to. How can
I
> > break apart what mysql spits out back into the year, month, day, time
> > variables?
> >
>
> In PHP you could try using the "split" or "explode" functions to return an
> array of the split apart items.
>
> ie.
>
> $date = "2002-10-20";
> $mdy = explode ("-", $date);
> echo date("F d, Y", mktime (0,0,0,$mdy[1], $mdy[2], $mdy[0]));
>
> Or one of the millions of variations of the above.
>
> > > > This is exactly what I'm doing! Here is my query ..
> > > >
> > > > select * from $dbtable where 1 and year = '$inyear' and month like
> > > > '$inmonth' and day = '$inday' order by time, ampm
> > > >
> > > > And when I display the results, it is putting a event of 10:00 am or
pm
> > > > before 2-9 am or pm. it's putting the 10 before all.
> > > >
> > > >
> > > > Here is a screen shot of the output..
> > > >
> > > > Time AM/PM Event Delete
> > > > 10:00 AM test
> > > > 10:00 PM test
> > > > 1:00 PM test
> > > > 5:00 AM test
> > > > 8:00 PM test
> > > > 9:00 AM test
> > > > 9:30 AM test
>
> --
> Brian Ashe CTO
> Dee-Web Software Services, LLC. [EMAIL PROTECTED]
>
>
>
> _______________________________________________
> Redhat-list mailing list
> [EMAIL PROTECTED]
> https://listman.redhat.com/mailman/listinfo/redhat-list
>
>
_______________________________________________
Redhat-list mailing list
[EMAIL PROTECTED]
https://listman.redhat.com/mailman/listinfo/redhat-list
