Posted by Steve on 04/14/07 18:30

date(format, strtotime(yourtimecolumn))

it is far faster to do it in the query though.

i do hope you work on your inline sql format though.


"Kevin Marks" <kevin@westportwa.com> wrote in message
news:dtWdncDITvSDY73bnZ2dnUVZ_s6onZ2d@comcast.com...
|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]