Shortened month

[compunet2]

I'm beating my head against the wall trying to figure out how to display a short textual representation of a month with php, while grabbing the data from mysql.

 

When I grab the data using:

$month=mysql_result($result,$i,"month");

 

$month display's: 09 (which is correct, september).

 

But when I try to grab the data using:

$month_short=date('M', mysql_result($result,$i,"month"));

 

$month_short, say's its Dec. 

 

How do I make month 9 display as Sept?

 

[.josh]

date does not require a 2nd argument (defaults to current timestamp), but the 2nd argument is expected to be a unix timestamp.  You are passing "09" to it, so it's looking at that as the entire timestamp.  you need to use mktime to fill in the rest of the timestamp:

 

$month_short=date('M', mktime(0,0,0,mysql_result($result,$i,"month"),0,0));