So I have a huge problem with probably a simple solution. But after hours of searching on google I gave up.
Here is my problem...
I have a date in my phpmyadmin that output like this 2014-01-20 but I want it to output like this 20 January, 2014.
It's "event_startdate" and "event_enddate" that I want to change.
Here is my code...
$event_list = "";
$sql = mysql_query ("SELECT * FROM events ORDER BY event_startdate ASC");
$eventCount = mysql_num_rows($sql); // Count number of rows to outpout.
if($eventCount > 0){
while($row = mysql_fetch_array($sql)){
$id = $row["id"];
$event_name = $row["event_name"];
$event_startdate = $row["event_startdate"];
$event_enddate = $row["event_enddate"];
$event_place = $row["event_place"];
$event_list .= '
<div class="eventlistpage">
<a href="event.php?id=' . $id .'">
<p id="eventNameBox">' . $event_name . '</p>
<p>' . $event_startdate . '</p>
<p>' . $event_enddate . '</p>
<p>' . $event_place . '</p>
</a>
<div class="clear"></div>
</div>';
}
} else {
}