Hi,
At the moment I am pulling a record from the database which is in datetime format. Could someone please tell me how I can modify this to just display the time and exclude the date?
Many thanks for any help.
<?php
$time = mysql_query("SELECT * FROM gps WHERE imei = '447779799009' ORDER BY gpstime DESC LIMIT 1");
while($row = mysql_fetch_array($time))
{
echo $row['gpstime'];
}
?>