Can I list the month name only once per listing of that month and display remaining rows of events showing only the day word and date numeral, as listed below
Sat 13th Jul --- Event 1
Sun 14th ------- Event 2
Mon 15th ------- Event 3
Thurs 1st Aug--Event 4
My code so far:
$start_date = "STR_TO_DATE(field_2,'%m %d %Y') AS startDate, DATE_FORMAT(STR_TO_DATE(field_2,'%m %d %Y'),'%a %D %b') AS startDate";
$query= "SELECT * ,$start_date FROM events ORDER BY STR_TO_DATE(field_2,'%m %d %Y') ASC ";
$result = mysql_query($query);
if (!$result) {
die(mysql_error());
}
while ($row = mysql_fetch_assoc($result))
{
echo $row['startDate']; // event date
echo" - ";
echo $row['field_1]; // venue
echo"<br />";
}