我已经打破了一种多对多的关系，其中一种只持有表的主键，一种称为subject，另一种则称为coarse Lectures。
我使用了mysql数据库中的下拉列表，我只需要一些关于如何将两个下拉选项发送到单独的mysql表中的指导。
<?php echo form_label('Lecturer :'); ?>
<?php $sql = "select id, email from coarse_lecturers ";
$result = mysql_query($sql);
echo "<select email = 'sub1'>";
while ($row = mysql_fetch_array($result)){
echo"<option value = '" . $row['id'] . "'>" . $row['email'] . "</option>";
}
echo "</select>";
?>
<?php echo form_label('Subject_ID :'); ?> <?php echo form_error('subjectID'); ?>
<?php $sql = "select subject_id,subject_name from subjects ";
$result = mysql_query($sql);
echo "<select subject_name = 'sub1'>";
while ($row = mysql_fetch_array($result)){
echo"<option value = '" . $row['subject_id'] . "'>" . $row['subject_name'] . "</option>";
}
echo "</select>";
?>
<?php echo form_submit(array('id' => 'submit', 'value' => 'Submit'));?>
开始工作了，
<?php echo form_label('Lecturer :'); ?> <?php echo form_error('dname'); ?>
<select name="lecturer">
<option value="none" selected="selected">------------Select Lecturer------------</option>
<?php $sql = "select id, email from coarse_lecturers ";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)){
echo"<option value = '" . $row['id'] . "'>" . $row['email'] . "</option>";
array('id' => 'lecturer', 'value' => 'lecturer');
}
echo "</select>";
?>