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"; }