Hi,
I have written this query but it does not display anything. What I am attempting to do, is to add up a total of ‘flighttime’ column, and display it only for the current day. The flighttime column is structured as a varchar, not by time.
$query = 'SELECT (SELECT COUNT(*) FROM `flighttime` WHERE `pilotid` = ID) as total, submitdate * FROM db_pireps';
$today = date('Y-m-d');
$submitdate = $query['submitdate'];
if($submitdate == $today)
{
mysql_fetch_array($query);
}
echo $query->total;