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
