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.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
