I have an events database and a script which displays a list of the events sorted by date. The date is stored in 3 tables, one for day, month and year.
I'm looking for a way to take the month output of say 05 (for may) and to replace it with May.
This is how the script is at present
while($row = mysql_fetch_array($result)) {
$the_month = $row["month"];
$the_day = $row["day"];
$the_year = $row["year"];
$the_location = $row["location"];
echo("\t<tr>\n\t\t<td>$the_day" . "/" . "$the_month" . "/" . "$the_year" . "</td>\n");
echo("\t\t<td>" . "$the_location" . "</td>\n");
Which gives the date as 21/05/2005 (uk format). I've read bits on str_replace but its way above me.
Can anyone help?
Matt