Здравствуйте хочу опять проконсультироваться на щет выпадающих списков, вот код
<?php
echo '<form method="post" action="">';
$ck = "<select id='id_ciklovKomis' name='nazv_ciklovKomis' size='1' onchange=\"this.form.submit();\">;
<option value='vse'>Производитель</option>";
$query = mysql_query("SELECT * FROM CiklovKomis ORDER BY id_ciklovKomis");
$result = mysql_fetch_array($query);
do
{
$ck .= "<option value='".$result['id_ciklovKomis']."'";
if (!empty($_POST['nazv_ciklovKomis']) && $_POST['nazv_ciklovKomis'] == $result['id_ciklovKomis']) {
$ck .= ' selected="selected"';
}
$ck .= ">".$result['nazv_ciklovKomis']."</option>";
}
while($result = mysql_fetch_array($query));
$ck.= "</select>";
echo $ck."";
if (!empty($_POST['nazv_ciklovKomis'])) {
$spec = "-<select id='id_specialnost' name='nazv_specialnosti' size='1' onchange=\"this.form.submit();\">;
<option value='vse'>Модель</option>";
$query = mysql_query("SELECT * FROM specialnost
WHERE id_ciklovKomis = '" . addslashes($_POST['nazv_ciklovKomis']) . "' ORDER BY id_specialnost");
$result = mysql_fetch_array($query);
do
{
$spec .= "<option value='".$result['id_specialnost']."'";
if (!empty($_POST['nazv_specialnosti']) && $_POST['nazv_specialnosti'] == $result['id_specialnost']) {
$spec .= ' selected="selected"';
}
$spec .= ">".$result['nazv_specialnosti']."</option>";
}
while($result = mysql_fetch_array($query));
$spec .= "</select>";
echo $spec.""."";
}
if (!empty($_POST['nazv_ciklovKomis']) && !empty($_POST['nazv_specialnosti'])) {
$grupa = "-<select id='id_groups' name='nazv_groups' size='1' onchange=\"this.form.submit();\">;
<option value='vse'>Год</option>";
$query = mysql_query("SELECT * FROM Groups
WHERE id_specialnost='" . addslashes($_POST['nazv_specialnosti']) . "' ORDER BY id_groups");
$result = mysql_fetch_array($query);
do
{
$grupa .= "<option value='".$result['id_groups']."'";
if (!empty($_POST['nazv_groups']) && $_POST['nazv_groups'] == $result['id_groups']) {
$grupa .= ' selected="selected"';
}
$grupa .= ">".$result['nazv_groups']."</option>";
}
while($result = mysql_fetch_array($query));
$grupa .= "</select>";
echo $grupa.""."";
if (!empty($_POST['nazv_ciklovKomis']) && !empty($_POST['nazv_specialnosti']) && !empty($_POST['nazv_groups'])); {
}
$st = "-<select id='id_student' name='lastname' size='1' onchange=\"this.form.submit();\">;
<option value='vse'>Модификация</option>";
$query = mysql_query("SELECT * FROM Students
WHERE id_groups='" . addslashes($_POST['nazv_groups']) . "' ORDER BY id_student");
$result = mysql_fetch_array($query);
do
{
$st .= "<option value='".$result['id_student']."'";
if (!empty($_POST['lastname']) && $_POST['lastname'] == $result['id_student']) {
$st .= ' selected="selected"';
}
$st .= ">".$result['lastname']."</option>";
}
while($result = mysql_fetch_array($query));
$st .= "</select>";
echo $st."<br>"."<br>";
}
if (!empty($_POST['nazv_ciklovKomis']) && !empty($_POST['nazv_specialnosti']) && !empty($_POST['nazv_groups'])&& !empty($_POST['lastname'])); {
}
echo '<p><table border = "1">
<tr>
<th>Название дисциплины</th>
<th>Вид контроля</th>
<th>Оценка</th>
<th>Дата сдачи</th>
</tr>';
$result = mysql_query ("SELECT nazv_discipline, vid_kontrolya, otsenka, date_sdachi
FROM Students
WHERE Students.id_student= '" . addslashes($_POST['lastname']) . "'
",$db);
while ($myrow = mysql_fetch_array ($result)){
$nazv_discipline = $myrow["nazv_discipline"];
$vid_kontrolya = $myrow["vid_kontrolya"];
$otsenka = $myrow["otsenka"];
$date_sdachi = $myrow["date_sdachi"];
echo "<tr>";
echo "<td>$nazv_discipline</td>";
echo "<td>$vid_kontrolya</td>";
echo "<td>$otsenka</td>";
echo "<td>$date_sdachi</td>";
echo "</tr>";
}
if (!empty($_POST['nazv_ciklovKomis']) && !empty($_POST['nazv_specialnosti']) && !empty($_POST['nazv_groups'])&& !empty($_POST['lastname']) && !empty($_POST['nazv_discipline'])); {
}
mysql_close($db);
echo '</table>';
echo "</form>";
?>
сюда бы нужно вставить два чек бокса и кнопку но кнопка должна по нажатию отправить данные с поля, $result['lastname'] и чекбоксов в файл обработчик но у меня поля построены без перезагрузки как же дописать отправку в обработчик?