= 0) $balance_text = $currencySymbol . number_format($balance,2); else $balance_text = "- $currencySymbol" . number_format(abs($balance),2); $acctBalance = $balance; // Get records to display $today = date("Y-m-d",time()); $now = date("Y-m-d H:i:s",time()); $cutoff = date("Y-m-d H:i:s",time() - 60 * 60 * 24 * 20); $query = "select * from hotlunch_schedules " . "where school_num = $school_num " . "and status = 'Active' " . "and start_order_datetime <= '$now' " . "and (schedule_end_date >= '$cutoff' OR end_order_datetime >= '$cutoff') " . "AND schedule_for = 'Anyone' " . "order by $scheduleSortOrder"; $schedules = db_query($query); if (db_num_rows($schedules) == 0) { echo("
There are no active schedules to view
\n"); ?>| Current Account Transaction Balance :: |