Posted by Kevin Marks on 04/14/07 16:14

I am trying to do it in PHP, not in the query.

"Steve" <no.one@example.com> wrote in message
news:QB6Uh.7$B42.1@newsfe02.lga...
>
> "Kevin Marks" <kevin@westportwa.com> wrote in message
> news:CqCdnTH2genfS73bnZ2dnUVZ_s-rnZ2d@comcast.com...
> |I have a MySQL database that contains a date field named TripDate.
> | I want to have it give me the name and number of the month, preferably
> in
> | two different variables.
> | How do I do this?
> |
> | $query="SELECT TripDate
> | FROM SCBoatTrips WHERE TripDate > '$Today'
> | ORDER BY TripDate";
> |
> | while ($row = mysql_fetch_array($result))
> | {
> | Print("$row[0]<br>");
> | }
>
> it depends on whether or not you want to do it in the query or by using
> php
> on the data after the query is run. based on that decision, RTCFM (where
> 'c'
> == 'correct')!!!
>
>

[Back to original message]