I am using a PHP Select statement to pull data from MySQL. The eventTime field is stored as TIME in the schema as HH:MM:SS but I only want HH:MM. I have tried using TIME_FORMAT(eventTime, '%H:%i') in the select statement but it does not work. Any ideas? I have even tried to convert the variable in PHP but I am stumped. Please help me identify what I'm missing.
$query="SELECT id,eventDate,eventTime, eventName FROM specialevents ORDER BY eventDate,eventTime ASC";
$result=$mysqliConnection->query($query,MYSQLI_STORE_RESULT);
while($row =$result->fetch_object())
{
$id=$row->id;
$eventDate=$row->eventDate;
$eventTime=$row->eventTime;
$eventName=$row->eventName;
$reportTime=$row->reportTime;
echo '<tr>’;
echo '<td class="tdId"><input type="text" class="tbId" value="' . $id . '"/></td>’;
echo '<td class="tdEventDate"><input type="text" class="tbEventDate" value="' . $eventDate . '"/></td>’;
echo '<td class="tdEventTime"><input type="text" class="tbEventTime" value="' . $eventTime . '"/></td>’;
echo '<td class="tdEventName"><input type="text" class="tbEventName" value=" ' . $eventTime . '"/></td>’;
echo '<td class="tdReportTime"><input type="text" class="tbReportTime" value=" ' . $reportTime . '"/></td>';
}