<form action='' method='POST' name='form'>
<?php
include_once 'db/connect.php';
$kaf = mysql_query ("SELECT (id_kaf) AS id_kaf, (kaf_name) AS kaf_name FROM kaf");
print "<p><select name='hero'>";
print "<option value=''>Оберіть кафедру</option>";
while ($row = mysql_fetch_array($kaf)) {
$id_kaf = $row["id_kaf"];
$kaf_name = $row["kaf_name"];
print "<option value='$id_kaf'>$kaf_name</option>";
}?>
</select></p>
<?php $rik = mysql_query ("SELECT (id_nrik) AS id_nrik, (rik) AS rik FROM nrik");
print "<p><select name='hero2'>";
print "<option value=''>Оберіть навчальний рік</option>";
while ($row = mysql_fetch_array($rik)) {
$id_nrik = $row["id_nrik"];
$rik = $row["rik"];
print "<option value='$id_nrik'>$rik</option>";
}?>
</select></p>
<?php $mis = mysql_query ("SELECT (id_nmis) AS id_nmis, (name) AS name FROM nmis");
print "<p><select name='hero3'>";
print "<option value=''>Оберіть місяць</option>";
while ($row = mysql_fetch_array($mis)) {
$id_nmis = $row["id_nmis"];
$name = $row["name"];
print "<option value='$id_nmis'>$name</option>";
}?>
</select></p>
<p></p>
<input type='submit' name='submit' value='Знайти' >
</form>
суть селекта, примерно такая:
SELECT fname, name, sname, kilg_osn, kilg_sum, kilg_dod, kilg_zam, komentar, razom FROM $pl, $vk" WHERE $hero=id_kaf AND $hero2=id_nrik AND $hero3=id_nmis;
где id_kaf, id_nrik, id_nmis из таблици $pl. Помогите, прошу Вас, сил уже нет ломать голову!