Re: Date Formatting Question

You got the right idea, but you're making it more complicated than it needs to be. your $sDate after using explode() is going to contain an array. strtotime doesn't take an array, it takes a string. $monthName = date("F", strtotime($row_events['Sdate'])); $monthNumber = date("m", strtotime($row_events['Sdate'])); // or "n" if you want "1" instead of "01" for January echo "<select name='sMonth'>\n"; for ($i = 1; $i <= 12; $i++) // using date() below to get month name, day and year irrelevant $selectMonthText = date("F", mktime(0, 0, 0, $i, 1, 2000)); if ($i == $monthNumber) $selected = " SELECTED"; else $selected = ""; echo "<option value='$i'$selected>$selectMonthText</option>\n"; echo "</select>\n"; -TG = = = Original message = = = I am trying to format the month portion of a date that I am trying to pull from MySQL to be placed into a drop down menu to modify the date. I have tried several ways and none seem to be working. I am pulling the date out of MySQL with: $sDate = explode("-", $row_events['Sdate']); And then attempting to insert each portion of the array into a drop down menu with: echo "<select name=Smonth>"; echo "<option selected>$sDate[1]</option>"; which is where I am running into the problem. I pull out the month as 2 digit numeric 01, 02, 03 etc., but I want it displayed as January, February, March, etc., I have tried the following with no success: Date("F",strtotime($sDate)); Strftime("%B:,$sDate); Date("F",$sDate); I would use MySQL to format the date, but I have three date fields to modify and it would be easier to do it in PHP Any pointers would be appreciated. Mark Bomgardner Technology Specialist KLETC ___________________________________________________________ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com.