<?php

require "conexao.php";

    if(isset($_GET['descricao_turma'])
    {

        $descricao_turma = $_GET['descricoes'];
        $result = mysql_query("select * from turma where codturma= $descricao_turma");

         while($row = mysql_fetch_array($result) )
     {
            echo "<option value='".$row['CODTURMA']."'>".$row['DESCRICAO']."</option>";

         }

     }

    if(isset($_GET['series'])
    {
           $serie = $_GET['series'];
           $result = mysql_query("SELECT serie.*, turma.*
                               from turma
                               join serie on serie.codserie = turma.codserie
                             where turma.codserie=$serie " );
          while($row = mysql_fetch_array($result) )
      {
            echo "<option value='".$row['CODSERIE']."'>".$row['DESCRICAO_SERIE']."</option>";

          }

     }

?>