if ( isset( $_GET['order']) & isset( $_REQUEST['fGhost_Hunt'] ) ) {
if ( $fGhost_Hunt == 'all' ) {
$query_Tour_Date = "SELECT * FROM license ORDER BY " . $_GET['order'];
}else{
$query_Tour_Date = "SELECT * FROM license WHERE Ghost_Hunt = '$fGhost_Hunt' ORDER BY " . $_GET['order'];
}
}elseif(
!isset($_GET['order']) & isset( $_REQUEST['fGhost_Hunt'] ) ){
if ( $fGhost_Hunt == 'all' ) {
$query_Tour_Date = "SELECT * FROM license ORDER BY Last_Name";
}else{
$query_Tour_Date = "SELECT * FROM license WHERE Ghost_Hunt = '$fGhost_Hunt' ORDER BY Last_Name";
}
}elseif(
isset($_GET['order']) & !isset( $_REQUEST['fGhost_Hunt'] ) ){
$query_Tour_Date = "SELEct * FROM license ORDER BY " . $_GET['order'];
}else{
$query_Tour_Date = "SELECT * FROM license ORDER BY Last_Name";
}