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

"Kevin Marks" <kevin [at] westportwa.com> wrote in message
news:CqCdnTH2genfS73bnZ2dnUVZ_s-rnZ2d [at] 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')!!!

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

"Steve" <no.one [at] example.com> wrote in message
news:QB6Uh.7$B42.1 [at] newsfe02.lga...
>
> "Kevin Marks" <kevin [at] westportwa.com> wrote in message
> news:CqCdnTH2genfS73bnZ2dnUVZ_s-rnZ2d [at] 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')!!!
>
>

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 [at] westportwa.com> wrote in message
news:dtWdncDITvSDY73bnZ2dnUVZ_s6onZ2d [at] comcast.com...
|I am trying to do it in PHP, not in the query.
|
| "Steve" <no.one [at] example.com> wrote in message
| news:QB6Uh.7$B42.1 [at] newsfe02.lga...
| >
| > "Kevin Marks" <kevin [at] westportwa.com> wrote in message
| > news:CqCdnTH2genfS73bnZ2dnUVZ_s-rnZ2d [at] 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')!!!
| >
| >
|
|