db_set_active('fbo_survey');
$q = "SELECT DISTINCT airport_state as state_name FROM fbo_airport t1
JOIN fbo_above_beyond_2015 t2 ON t1.airport_id = t2.airport_code
WHERE t1.airport_country = 'UNITED STATES'
ORDER BY 1;";
$states = db_query($q); $k = 'active';
foreach($states as $state){ ??>
$r = "SELECT DISTINCT fbo_name, airport_code FROM fbo_above_beyond_2015 t1
JOIN fbo_airport t2 ON t1.airport_code = t2.airport_id
WHERE t2.airport_state = '$state-?>state_name'
ORDER BY 1;";
$fbos = db_query($r);
foreach($fbos as $fbo){ ?>
fbo_name . ' (' . $fbo->airport_code . ')'; ?>
$s = "SELECT DISTINCT name FROM fbo_above_beyond_2015
WHERE airport_code = '$fbo-?>airport_code' AND fbo_name = '" . addslashes($fbo->fbo_name) . "'
ORDER BY 1;";
$names = db_query($s);
foreach($names as $name){ ?>
name; ?>
name) . "' AND airport_code = '$fbo->airport_code';";
$comments = db_query($t);
foreach($comments as $comment){
if(!empty($comment->comment)) { ?>
“comment; ?>”
} // end comments foreach
} // end name foreach
} // end fbo foreach ??>
db_set_active(); // back to drupal
??>
