<?php 
    $ano = $curso = $disciplina = $modulo = $eq = null; //declare vars 
 
 
    $conn = mysql_connect("localhost", "root", ""); 
    $db = mysql_select_db('concrete',$conn); 
 
    if(isset($_GET["cod_ano"]) && is_numeric($_GET["cod_ano"])) 
    { 
    $ano = $_GET["cod_ano"]; 
    } 
 
   if(isset($_GET["cod_curso"]) && is_numeric($_GET["cod_curso"])) 
    { 
    $curso = $_GET["cod_curso"]; 
    } 
 
   if(isset($_GET["cod_disciplina"]) && is_numeric($_GET["cod_disciplina"])) 
    { 
    $disciplina = $_GET["cod_disciplina"]; 
    } 
 
   if(isset($_GET["cod_modulo"]) && is_numeric($_GET["cod_modulo"])) 
    { 
    $modulo = $_GET["cod_modulo"]; 
    } 
 
 
   if(isset($_GET["cod_eq"]) && is_numeric($_GET["cod_eq"])) 
    { 
    $eq = $_GET["cod_eq"]; 
   $eq2 = $_GET["cod_eq"];
    } 
     ?>
 
    //if u know another script like this it would be awsome cause this one reloads the page and i dont want that...
    <script language="JavaScript"> 
    function autoSubmit() 
    { 
    var formObject = document.forms['theForm']; 
    formObject.submit(); 
    } 
    </script> 
 
 
 
 
 
   <form  id ="theForm" name="theForm" method="GET" action="insertReq.php" > 
    <div style="width:1100px; height:768px;">
 
 
    <table width="1090" height="659" border="0">
 
      <tr>
        <td width="545" height="551"><div style="margin-left:65px;"><p>
          <select style="width:160px;"  name="cod_ano" onChange="autoSubmit();"> 
            <option  value="cod_ano">Selecione o Ano</option> 
            <?php 
    $sql = "SELECT * FROM ano"; 
    $array1 = mysql_query($sql,$conn); 
    while($row = mysql_fetch_array($array1)) 
    { 
    echo ("<option value=\"$row[cod_ano]\" " . ($ano == $row["cod_ano"]? " selected" : "") . ">$row[nome_ano]</option>"); 
    } 
    ?> 
          </select> 
          <?php 
    if($ano!= null && is_numeric($ano)) 
    { 
?>
          <select style="width:260px;" name="cod_curso" onChange="autoSubmit();"> 
            <option value="cod_curso">Selecione o curso</option> 
            <?php 
    $sql2 = "SELECT * FROM curso WHERE cod_ano = $ano "; 
    $array2 = mysql_query($sql2,$conn); 
    while($row = mysql_fetch_array($array2)) 
    { 
    echo ("<option value=\"$row[cod_curso]\" " . ($curso == $row["cod_curso"]? " selected" : "") . ">$row[nome_curso]</option>"); 
    } 
    ?> 
          </select>
          <?php 
    if($curso!= null && is_numeric($curso)) 
    { 
?>
          <br>
  <br>
 
          <select style="width:250px;" name="cod_disciplina" onChange="autoSubmit();"> 
            <option value="cod_disciplina">Selecione a disciplina</option> 
            <?php 
    $sql3 = "SELECT * FROM disciplina WHERE cod_ano = $ano AND cod_curso = $curso "; 
    $array3 = mysql_query($sql3,$conn); 
    while($row = mysql_fetch_array($array3)) 
    { 
    echo ("<option value=\"$row[cod_disciplina]\" " . ($disciplina == $row["cod_disciplina"]? " selected" : "") . ">$row[nome_disciplina]</option>"); 
    } 
    ?> 
          </select> 
          <?php 
    if($disciplina!= null && is_numeric($disciplina)) 
    { 
?>
 
          <select name="sala" style="width:160px;" onChange="autoSubmit();"> 
            <option>Selecione a Sala</option> 
            <option>Labor. de Audiovisual</option> 
            <option>Labor. de Fotografia</option>
            <option>Sala de Desenho</option> 
            <option>Anfiteatro</option> 
            <option>1</option> 
            <option>2</option> 
            <option>3</option> 
            <option>4</option> 
            <option>5</option> 
            <option>6</option>
            <option>7</option>
            <option>8</option>
            <option>9</option>
            <option>Inf1</option>
            <option>Inf2</option>
            <option>Inf3</option>
 
          </select>
          <?php
   } } }
   ?>
       <p><strong><em>Equipamento:</em></strong></p>
        <p>
          <select style="width:300px;" id ="cod_eq" name="cod_eq">
            <option value="cod_eq">Selecione o Equipamento</option>
            <?php 
    $sql5 = "SELECT * FROM equipamentos"; 
    $array5 = mysql_query($sql5,$conn); 
    while($row = mysql_fetch_array($array5)) 
    { 
    echo ("<option value=\"$row[cod_eq]\" " . ($eq == $row["cod_eq"]? " selected" : "") . ">$row[nome_eq]</option>"); 
    } 
    ?>
          </select>
          <select name="qnt1" style="width:80px;">
            <option>Qnt.</option>
            <option>1</option>
            <option>2</option>
            <option>3</option>
            <option>4</option>
            <option>5</option>
          </select>
          <br /><br />
          <select style="width:300px;" id ="cod_eq" name="cod_eq2">
            <option value="cod_eq">Selecione o Equipamento</option>
            <?php 
    $sql5 = "SELECT * FROM equipamentos"; 
    $array5 = mysql_query($sql5,$conn); 
    while($row = mysql_fetch_array($array5)) 
    { 
    echo ("<option value=\"$row[cod_eq]\" " . ($eq == $row["cod_eq"]? " selected" : "") . ">$row[nome_eq]</option>"); 
    } 
    ?>
          </select>
          <select name="qnt2" style="width:80px;">
            <option>Qnt.</option>
            <option>1</option>
            <option>2</option>
            <option>3</option>
            <option>4</option>
            <option>5</option>
          </select>