You got the right idea, but you're making it more complicated than it needs to 

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";
    $selected = "";
  echo "<option value='$i'$selected>$selectMonthText</option>\n";

echo "</select>\n";


= = = 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:

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

Sent by ePrompter, the premier email notification software.
Free download at

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to