kevin marks

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>");
}

steve

|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')!!!

kevin marks

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

steve

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.


|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')!!!
| >
| >
|
|