[RESOLVE] Parse MySQL time format HH:MM:SS into each variable

[Wdblazer]

I have an select option in php that show the default as the selected time from database. The time format from MYSQL is HH:MM:SS, how do I separate them into each variable, $eventTimeHour = HH, $eventTimeMin =MM?

 <?php
	//Mysql code for connection and retrieving the result here;
	// $eventTime is given as HH:MM:00
	//how to parse them as $eventTimeHour = HH and $eventTimeMin = MM?
	$eventTime = $row['TIME'];

	for ($hr = 1; $hr < 13; $hr++)
    {
		$hr = str_pad($hr, 2, '0', STR_PAD_LEFT);
		if ($hr == $eventTimeHour)
		{
			echo "<option selected>$hr</option>";
		}
		else
		{
    		echo "<option>$hr</option>";
		}
	 }

    </select>
<select name="EventTimeMin" id="EventTimeMin">
<?php
	for ($min = 00; $min < 60; $min++)
    {
		$min = str_pad($min, 2, '0', STR_PAD_LEFT);
		if ($min == $eventTimeMin)
		{
			echo "<option selected>$min</option>";
		}
		else
		{
    	echo "<option>$min</option>";
		}
	 }
?>

edit: silly me, I remember the substr function and is using it to get the first 2 and 4th and 5th digits.