常連

現在、大学の履修登録機能の実装を目指しております。
★実装機能、情報★
❶学生（学部、名前、パス）、講師（名前、学部）、講義（開講日時、担当講師、受講可能学部、単位数）が存在する
　　　＊学生のパスはログイン時に使用
❷学生の履修登録時には、学生の学部と講義の受講可能学部が一致した講義のみを学生に選択させる。
❸❷の実行時には開講日時による絞り込みをする、（例MOn2,Tue3,Fri1など）
❹単位数が４のクラスは週に２回のクラスがある。（例economics講義はTue2とFri4の開講である）

というのが大まかな情報です。ちなみに実装は完了しております。

★問題点★
経済学部の学生がログインするとeconomics講義（Tue2とFri4による週2回講義）が選択可能ですがその際、Tue2(Fri4)のeconomics講義をセレクトで選択するとJSでFri4(Tue2)も選択された状態にしたいのですが、その際のJSの書き方がわかりません。答えを頂戴する場所ではないみたいですが実際のコードを添えていただけると助かります。

★備考★
大変長くなっておりますが、解決したいのはJSの部分のみです。回答者様が実際にコードを確認される際の為に全て載せております。
またデータが多すぎため質問を分割し、データを貼ります。
```SQL
CREATE TABLE `students` (
  `student_id` varchar(6) NOT NULL,
  `studentname` varchar(100) NOT NULL,
  `pass` varchar(100) NOT NULL,
  `major` enum('AD01','EC01','ED01','EL01','EL02','IS01','LA01') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `students`
--

INSERT INTO `students` (`student_id`, `studentname`, `pass`, `major`) VALUES
('AD0001', 'Frank', 'temp', 'AD01'),
('AD0002', 'Fox', 'temp', 'AD01'),
('AD0003', 'Ross', 'temp', 'AD01'),
('AD0004', '井上建', 'temp', 'AD01'),
('AD0005', 'Bob', 'temp', 'AD01'),
('ED0001', 'Emilly', 'temp', 'ED01'),
('ED0002', 'Fan', 'temp', 'ED01'),
('ED0003', 'Hanks', 'temp', 'ED01'),
('ED0004', 'Ellen', 'temp', 'ED01'),
('ED0005', 'Tom', 'temp', 'ED01'),
('EL0001', '浜田省吾', 'temp', 'EL01'),
('EL0002', 'David', 'temp', 'EL01'),
('EL0003', 'Rora', 'temp', 'EL01'),
('EL0004', 'Tim', 'temp', 'EL01'),
('EL0005', 'Ron', 'temp', 'EL01'),
('EL2001', '野村祐輔', 'temp', 'EL02'),
('EL2002', 'Tobby', 'temp', 'EL02'),
('EL2003', 'Nancy', 'temp', 'EL02'),
('EL2004', 'Lisa', 'temp', 'EL02'),
('EL2005', 'Serena', 'temp', 'EL02'),
('IS0001', 'Chandler', 'temp', 'IS01'),
('IS0002', '中井悠太', 'temp', 'IS01'),
('IS0003', 'Mike', 'temp', 'IS01'),
('IS0004', '王建民\r\n', 'temp', 'IS01'),
('IS0005', 'Monica', 'temp', 'IS01'),
('LA0001', 'Joye', 'temp', 'LA01'),
('LA0002', 'Rachel', 'temp', 'LA01'),
('LA0003', 'Ken', 'temp', 'LA01'),
('LA0004', 'Tag', 'temp', 'LA01'),
('LA0005', 'Carol', 'temp', 'LA01');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `students`
--
ALTER TABLE `students`
  ADD PRIMARY KEY (`student_id`);

```

```SQL
CREATE TABLE `teachers` (
  `teacher_id` int(11) NOT NULL,
  `teachername` varchar(50) NOT NULL,
  `department` enum('AD01','EC01','ED01','EL01','EL02','IS01','LA01','NONE') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `teachers`
--

INSERT INTO `teachers` (`teacher_id`, `teachername`, `department`) VALUES
(1, '西川憲二', 'AD01'),
(2, '斎藤みき', 'AD01'),
(3, 'TomHanks', 'AD01'),
(4, 'Matthew Perry', 'EC01'),
(5, 'Matt Leblanc', 'EC01'),
(6, 'Jennifer Aniston', 'EC01'),
(7, 'Courteney Cox', 'EL01'),
(8, '町史寛二', 'EL01'),
(9, 'Irfan Khan', 'EL01'),
(10, 'Chu Yu-hsien', 'EL01'),
(11, 'Chen Chieh-hsien', 'EL02'),
(12, 'C.C.Lee', 'EL02'),
(13, 'Bill Clinton', 'EL02'),
(14, 'Will  Smith', 'IS01'),
(15, 'Liv Tyler', 'IS01'),
(16, 'Kim Kardashian', 'IS01'),
(17, 'Katy Perry', 'IS01'),
(18, 'Julia Roberts', 'LA01'),
(19, 'Ben Affleck', 'LA01'),
(20, 'Jodie Foster', 'LA01'),
(21, 'Al Gore', 'LA01'),
(22, 'Ellen DeGeneres', 'NONE'),
(23, '十亀 新一', 'NONE'),
(24, 'Kanye West', 'NONE'),
(25, 'Miley Cyrus', 'NONE'),
(26, 'Mel Gibson', 'AD01'),
(27, 'John F.kennedy', 'EC01'),
(28, 'Charlie Sheen', 'ED01'),
(29, 'Paris Hilton', 'ED01'),
(30, 'Britney Spears', 'ED01'),
(31, 'Eric Geller', 'EC01'),
(32, 'Yuta Nakai', 'EC01');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `teachers`
--
ALTER TABLE `teachers`
  ADD PRIMARY KEY (`teacher_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `teachers`
--
ALTER TABLE `teachers`
  MODIFY `teacher_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

```

```SQL
CREATE TABLE `majors` (
  `code` enum('AD01','EC01','ED01','EL01','EL02','IS01','LA01') NOT NULL,
  `name` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `majors`
--

INSERT INTO `majors` (`code`, `name`) VALUES
('AD01', '広告'),
('EC01', '経済'),
('ED01', '教育'),
('EL01', '電機'),
('EL02', '電子'),
('IS01', '情報システム'),
('LA01', '法律');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `majors`
--
ALTER TABLE `majors`
  ADD PRIMARY KEY (`code`);

```

```SQL
CREATE TABLE `classes` (
  `class_id` int(11) NOT NULL,
  `classname` varchar(100) NOT NULL,
  `teacher_id` int(11) NOT NULL,
  `credit` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `classes`
--

INSERT INTO `classes` (`class_id`, `classname`, `teacher_id`, `credit`) VALUES
(1, 'How to use java', 14, 2),
(2, 'How to use PHP', 15, 2),
(3, 'How to use C++', 16, 2),
(4, 'How to use Ruby', 17, 2),
(5, 'Medieval philosophy', 28, 2),
(6, 'Economics', 4, 4),
(7, 'About basic advertising', 1, 2),
(8, 'Different types of advertising methods', 2, 2),
(9, 'Basic psychology', 29, 2),
(10, 'Roman history', 25, 2),
(11, 'Civil engineering', 11, 2),
(12, 'Electronic engineering', 12, 2),
(13, 'Electrical engineering', 9, 2),
(14, 'Basic engineering', 10, 2),
(15, 'Making web systems with PHP language', 15, 2),
(16, 'How to learn Coding', 14, 2),
(17, 'Mathematics', 30, 2),
(18, 'Linguistics', 29, 4),
(19, 'Japanese language', 23, 1),
(20, 'Spanish language', 24, 1),
(21, 'English discussion', 30, 2),
(22, 'Basic law', 18, 2),
(23, 'International law', 19, 2),
(24, 'Corporate law', 20, 2),
(25, 'Basic education', 28, 2),
(26, 'Secondary education', 30, 2),
(27, 'About the knowledge of infancy', 28, 2),
(28, 'The way of getting children excited', 29, 2),
(29, 'Contemporary economics', 5, 2),
(30, 'Math of economics', 6, 2),
(31, 'Color schema in business', 3, 2),
(32, 'The art', 26, 2),
(35, 'About Problems of electricity that cities have', 8, 2),
(36, 'Electric power', 7, 2),
(37, 'Making electronic products', 13, 2),
(38, 'American law', 21, 2),
(39, 'Economic effectiveness', 27, 2),
(40, 'Olympic economy', 31, 4),
(41, 'Seles in economy', 32, 2);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `classes`
--
ALTER TABLE `classes`
  ADD PRIMARY KEY (`class_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `classes`
--
ALTER TABLE `classes`
  MODIFY `class_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

```

```SQL
CREATE TABLE `classdates` (
  `classdate_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `teacher_id` int(11) NOT NULL,
  `date` enum('Mon1','Mon2','Mon3','Mon4','Mon5','Tue1','Tue2','Tue3','Tue4','Tue5','Wed1','Wed2','Wed3','Wed4','Wed5','Thu1','Thu2','Thu3','Thu4','Thu5','Fri1','Fri2','Fri3','Fri4','Fri5') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `classdates`
--

INSERT INTO `classdates` (`classdate_id`, `class_id`, `teacher_id`, `date`) VALUES
(1, 1, 14, 'Mon5'),
(2, 2, 15, 'Mon5'),
(3, 3, 16, 'Mon1'),
(5, 4, 17, 'Fri1'),
(6, 5, 28, 'Wed1'),
(7, 6, 4, 'Tue2'),
(10, 6, 4, 'Fri4'),
(11, 7, 1, 'Thu1'),
(12, 8, 2, 'Mon1'),
(13, 9, 29, 'Tue1'),
(14, 10, 25, 'Thu4'),
(15, 11, 11, 'Mon5'),
(16, 12, 12, 'Fri4'),
(17, 13, 9, 'Fri3'),
(18, 14, 10, 'Tue5'),
(19, 15, 15, 'Thu4'),
(20, 16, 14, 'Wed1'),
(21, 17, 30, 'Wed2'),
(22, 18, 29, 'Mon4'),
(23, 19, 23, 'Thu2'),
(24, 20, 24, 'Tue3'),
(26, 21, 30, 'Wed3'),
(27, 22, 18, 'Mon2'),
(28, 23, 19, 'Mon3'),
(29, 24, 20, 'Tue5'),
(30, 25, 28, 'Wed4'),
(31, 26, 30, 'Wed5'),
(32, 18, 29, 'Tue3'),
(33, 27, 28, 'Tue4'),
(34, 28, 29, 'Fri2'),
(35, 30, 6, 'Fri5'),
(36, 31, 3, 'Mon3'),
(37, 32, 26, 'Fri3'),
(38, 35, 8, 'Thu3'),
(39, 36, 7, 'Tue2'),
(40, 37, 13, 'Thu2'),
(41, 38, 21, 'Wed4'),
(42, 39, 27, 'Wed5'),
(43, 29, 5, 'Thu2'),
(44, 40, 31, 'Tue2'),
(45, 40, 31, 'Fri4'),
(46, 41, 32, 'Tue2');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `classdates`
--
ALTER TABLE `classdates`
  ADD PRIMARY KEY (`classdate_id`),
  ADD UNIQUE KEY `ix01_classdates` (`class_id`,`date`),
  ADD UNIQUE KEY `ix02_classdates` (`teacher_id`,`date`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `classdates`
--
ALTER TABLE `classdates`
  MODIFY `classdate_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

```

```SQL
CREATE TABLE `available` (
  `class_id` int(11) NOT NULL,
  `major` enum('AD01','EC01','ED01','EL01','EL02','IS01','LA01','ALL') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `available`
--

INSERT INTO `available` (`class_id`, `major`) VALUES
(1, 'IS01'),
(2, 'IS01'),
(3, 'IS01'),
(4, 'IS01'),
(5, 'ALL'),
(6, 'EC01'),
(6, 'ED01'),
(6, 'LA01'),
(7, 'AD01'),
(7, 'ED01'),
(8, 'AD01'),
(9, 'ALL'),
(10, 'ALL'),
(11, 'EL01'),
(11, 'EL02'),
(12, 'EL02'),
(13, 'EL01'),
(14, 'EL01'),
(14, 'EL02'),
(14, 'IS01'),
(15, 'EL01'),
(15, 'EL02'),
(15, 'IS01'),
(16, 'EL01'),
(16, 'EL02'),
(16, 'IS01'),
(17, 'ALL'),
(18, 'ALL'),
(19, 'ALL'),
(20, 'ALL'),
(21, 'ALL'),
(22, 'ALL'),
(23, 'LA01'),
(24, 'LA01'),
(25, 'ALL'),
(26, 'AD01'),
(26, 'ED01'),
(27, 'ED01'),
(28, 'AD01'),
(28, 'ED01'),
(29, 'EC01'),
(30, 'EC01'),
(31, 'AD01'),
(31, 'IS01'),
(32, 'AD01'),
(35, 'EL01'),
(35, 'EL02'),
(36, 'EL01'),
(37, 'EL02'),
(38, 'LA01'),
(39, 'AD01'),
(40, 'EC01'),
(40, 'ED01'),
(41, 'ALL');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `available`
--
ALTER TABLE `available`
  ADD PRIMARY KEY (`class_id`,`major`);

```

以上です。生徒が申請を完了した際にそのテーブルを登録するテーブルなどはありますが、この質問いは関係ないので省略します。

	@@ -1 +1 @@
1	- PHPとJavaScriptによるselect値の変更
1	+ PHPとJavaScriptによるselect値の変更❶（コードはSQLのみ）

質問編集履歴