\n"; while ($d = db_fetch_array($r, MYSQL_ASSOC)) { extract($d, EXTR_PREFIX_ALL, 's'); if ($s_people_type == 'Student') { $u = db_query("SELECT * FROM users WHERE record_num = $s_user_num"); $ur = db_fetch_array($u, MYSQL_ASSOC); extract($ur, EXTR_PREFIX_ALL, 'u'); } // Check if this person has an order $query = "SELECT count(*) FROM hotlunch_order_header " . "WHERE school_num = $schoolId " . "AND ordered_by_num = $s_record_num " . "AND schedule_num = $scheduleNum"; $num_orders = db_getVal($query); $has_order = "No"; if ($num_orders == 1) $has_order = "Yes"; $results .= "

$s_first_name $s_last_name

\n"; } $results .= "\n"; echo($results); ?>