[mysql+php] dateformat function - creating a timetable

[Costas]

reference
http://www.w3schools.com/sql/func_date_format.asp

using the mysql date_format will help me to split the date by the time and vice versa..

//test
<div style="font-family: 'Roboto', sans-serif;font-size:26px;font-weight: bold;color:#B0166C;"> Program</div>
<?php 
 		$timetable = getSet($db,"select event_timeline_id,DATE_FORMAT(event_timeline_time,'%d %b, %Y') as eventdate, DATE_FORMAT(event_timeline_time,'%H:%i') as eventtime,event_timeline_descr from event_timeline where event_id=? order by event_timeline_time ASC",array($event_id));
 		
 		$last_datetime="";
 		$day=0;
 		
 		foreach ($timetable as $time) { 
 			if ($last_datetime!=$time['eventdate'])
 			{   
 				echo "<div style='margin-bottom:5px;border-bottom:3px #B0166C solid'] </div>";
 				$day+=1;

				echo "[B] Day {$day} : [/B][B]{$time['eventdate']}[/B]<br/><br/>";
			}
			else 
				echo "[HR][/HR]";
 						
			echo "[B] {$time['eventtime']} [/B][B]{$time['event_timeline_descr']}[/B]";
			
 			$last_datetime = $time['eventdate'];
 		}
?>

the dbase records

running my query

select event_timeline_id,DATE_FORMAT(event_timeline_time,'%d %b, %Y') as eventdate, DATE_FORMAT(event_timeline_time,'%H:%i') as eventtime,event_timeline_descr from event_timeline where event_id=? order by event_timeline_time ASC

 

 
 
the result :

CREATE TABLE event_timeline (
  event_timeline_id int(11) NOT NULL AUTO_INCREMENT,
  event_id int(11) DEFAULT NULL,
  event_timeline_time datetime DEFAULT NULL,
  event_timeline_descr text COLLATE utf8_unicode_ci,
  PRIMARY KEY (event_timeline_id)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;