month as name

[bjblackmore]

Hi,

I am storing dates in my database, which has a field for day, month, year. I am storing the month as a 2 digit format (06 = june) when I display the dates on the page, I want to convert the digits to the month name. So 06 becomes June. I am using the following code, however $monthname always seems to be the 1st month in the database. i.e. if i have
| 08 | 06 | 2002 |
| 01 | 07 | 2002 |
| 01 | 09 | 2002 |

The month will always be June, and not July, or September.

$sql = "SELECT day,month,year FROM availability";
$result=db_query($sql);
while($row=mysql_fetch_array($result)){
$day = $row['day'];
$month = $row['month'];
$year = $row['year'];

if ($month == 01){
$monthname = "January";
}
elseif ($month == 02){
$monthname = "February";
}
elseif ($month == 03){
$monthname = "March";
}
elseif ($month == 04){
$monthname = "April";
}
elseif ($month == 05){
$monthname = "May";
}
elseif ($month == 06){
$monthname = "June";
}
elseif ($month == 07){
$monthname = "July";
}
elseif ($month == 08){
$monthname = "August";
}
elseif ($month == 09){
$monthname = "September";
}
elseif ($month == 10){
$monthname = "October";
}
elseif ($month == 11){
$monthname = "November";
}
elseif ($month == 12){
$monthname = "December";
}
echo "$day, $monthname, $year";
}

[cwspen]

I'm not sure why it isn't working as you want but why not create an array with the month names, and then use the value from the DB as an index?

i.e.

<?php
$monthtxt = array ('1' => 'January','February','March','April','May','June','July','August','September','October','November','December');
$sql = "SELECT day,month,year FROM availability";
$result=db_query($sql);
while($row=mysql_fetch_array($result)){
$day = $row['day'];
$month = $row['month'];
$year = $row['year'];

echo $day, $monthtxt[$month], $year;
}

Try that, it should work.

[tomhath]

Messing with dates in this format is too much trouble. Thebest way to deal with dates it with a UNIX_TIMESTAMP. You can get any of the compnents (month, day, year); you can do arithmetic (add days, take the difference of two timestamps, etc).

Doing it yourself you have to deal with all kinds of rollover problems (month to next month, but how many days in a month, and how many days in a year?). Timestamps are your friend.