Are there any PHP functions for manipulating that data? Like subtracting a start time from a finish time to establish an elapsed time. If it were a "datetime" column I could ise the date() functionality, but I've checked in PHP docs and MySQL docs and done a search in these forums (fora?) and I cannot find anything similar for the "time" string.
Similarly with numbers stored as type "decimal" in MySQL. I know they are stored as strings, but I assume I can convert them simply enough by doing
Code: Select all
<?php
$Amount = 0.00 + $Row['Amount'];
?>