varios campos p/ pesquisa no bd

[elizeu 0]

bacanas.. tendo esses campos ], como farei pra pesquisar isso no banco de daddos? checo um por um ?

<form name="buscareq" method="post" action="?op=Pesquisar">  <table width="100%" border="1" cellspacing="1" cellpadding="0">    <tr>      <td><table width="100%" border="0" cellpadding="0" cellspacing="1" bordercolor="#0066CC">          <tr>             <td width="29%" bgcolor="#F5F5F5"><strong>Por Nº:</strong></td>            <td width="71%" bgcolor="#F5F5F5"> <select name="numero" id="numero">                <option value="                                           ">-                 - - - - - - - </option>              </select> </td>          </tr>          <tr>             <td bgcolor="#F5F5F5"><strong>Por Material:</strong></td>            <td bgcolor="#F5F5F5"><select name="material" id="material">                <option>- - - - - - - - </option>              </select> </td>          </tr>          <tr>             <td bgcolor="#F5F5F5"><strong>Por Serviço:</strong></td>            <td bgcolor="#F5F5F5"><select name="servico" id="servico">                <option>- - - - - - - - </option>              </select> </td>          </tr>          <tr>             <td bgcolor="#F5F5F5"><strong>Por Data de Aplicação:</strong></td>            <td bgcolor="#F5F5F5"><strong><span class="comText">               <SELECT name="data_apli_d" id="data_apli_d">                <OPTION value=Dia selected>Dia</OPTION>                <OPTION value="01">1</OPTION>                <OPTION value="02">2</OPTION>                <OPTION value="03">3</OPTION>                <OPTION value="04">4</OPTION>                <OPTION value="05">5</OPTION>                <OPTION value="06">6</OPTION>                <OPTION value="07">7</OPTION>                <OPTION value="08">8</OPTION>                <OPTION value="09">9</OPTION>                <OPTION value="10">10</OPTION>                <OPTION value="11">11</OPTION>                <OPTION value="12">12</OPTION>                <OPTION value="13">13</OPTION>                <OPTION value="14">14</OPTION>                <OPTION value="15">15</OPTION>                <OPTION value="16">16</OPTION>                <OPTION value="17">17</OPTION>                <OPTION value="18">18</OPTION>                <OPTION value="19">19</OPTION>                <OPTION value="20">20</OPTION>                <OPTION value="21">21</OPTION>                <OPTION value="22">22</OPTION>                <OPTION value="23">23</OPTION>                <OPTION value="24">24</OPTION>                <OPTION value="25">25</OPTION>                <OPTION value="26">26</OPTION>                <OPTION value="27">27</OPTION>                <OPTION value="28">28</OPTION>                <OPTION value="29">29</OPTION>                <OPTION value="30">30</OPTION>                <OPTION value="31">31</OPTION>              </SELECT>              /               <SELECT name="data_apli_m" id="data_apli_m">                <OPTION value=Mês selected>Mês</OPTION>                <OPTION value="01">Janeiro</OPTION>                <OPTION value="02">Fevereiro</OPTION>                <OPTION value="03">Março</OPTION>                <OPTION value="04">Abril</OPTION>                <OPTION value="05">Maio</OPTION>                <OPTION value="06">Junho</OPTION>                <OPTION value="07">Julho</OPTION>                <OPTION value="08">Agosto</OPTION>                <OPTION value="09">Setembro</OPTION>                <OPTION value="10">Outubro</OPTION>                <OPTION value="11">Novembro</OPTION>                <OPTION value="12">Dezembro</OPTION>              </SELECT>              /               <SELECT name="data_apli_a" id="data_apli_a">                <OPTION value="2005" selected>2005</OPTION>                <OPTION value="2006">2006</OPTION>                <OPTION value="2007">2007</OPTION>                <OPTION value="2008">2008</OPTION>              </SELECT>              </span></strong></td>          </tr>          <tr>             <td bgcolor="#F5F5F5"><strong>Por Data de Requerimento:</strong></td>            <td bgcolor="#F5F5F5"><strong><span class="comText">               <SELECT name="data_req_d" id="select">                <OPTION value=Dia selected>Dia</OPTION>                <OPTION value="01">1</OPTION>                <OPTION value="02">2</OPTION>                <OPTION value="03">3</OPTION>                <OPTION value="04">4</OPTION>                <OPTION value="05">5</OPTION>                <OPTION value="06">6</OPTION>                <OPTION value="07">7</OPTION>                <OPTION value="08">8</OPTION>                <OPTION value="09">9</OPTION>                <OPTION value="10">10</OPTION>                <OPTION value="11">11</OPTION>                <OPTION value="12">12</OPTION>                <OPTION value="13">13</OPTION>                <OPTION value="14">14</OPTION>                <OPTION value="15">15</OPTION>                <OPTION value="16">16</OPTION>                <OPTION value="17">17</OPTION>                <OPTION value="18">18</OPTION>                <OPTION value="19">19</OPTION>                <OPTION value="20">20</OPTION>                <OPTION value="21">21</OPTION>                <OPTION value="22">22</OPTION>                <OPTION value="23">23</OPTION>                <OPTION value="24">24</OPTION>                <OPTION value="25">25</OPTION>                <OPTION value="26">26</OPTION>                <OPTION value="27">27</OPTION>                <OPTION value="28">28</OPTION>                <OPTION value="29">29</OPTION>                <OPTION value="30">30</OPTION>                <OPTION value="31">31</OPTION>              </SELECT>              /               <SELECT name="data_req_m" id="select2">                <OPTION value=Mês selected>Mês</OPTION>                <OPTION value="01">Janeiro</OPTION>                <OPTION value="02">Fevereiro</OPTION>                <OPTION value="03">Março</OPTION>                <OPTION value="04">Abril</OPTION>                <OPTION value="05">Maio</OPTION>                <OPTION value="06">Junho</OPTION>                <OPTION value="07">Julho</OPTION>                <OPTION value="08">Agosto</OPTION>                <OPTION value="09">Setembro</OPTION>                <OPTION value="10">Outubro</OPTION>                <OPTION value="11">Novembro</OPTION>                <OPTION value="12">Dezembro</OPTION>              </SELECT>              /               <SELECT name="data_req_a" id="data_req_a">                <OPTION value="2005" selected>2005</OPTION>                <OPTION value="2006">2006</OPTION>                <OPTION value="2007">2007</OPTION>                <OPTION value="2008">2008</OPTION>              </SELECT>              </span></strong></td>          </tr>          <tr>             <td bgcolor="#F5F5F5"><strong>Por Disciplina:</strong></td>            <td bgcolor="#F5F5F5"> <select name="disciplina" id="disciplina">                <option>- - - - - - - - </option>              </select></td>          </tr>          <tr>             <td height="21" bgcolor="#F5F5F5"><strong>Por Turma:</strong></td>            <td bgcolor="#F5F5F5"> <select name="turma" id="turma">                <option>- - - - - - - - </option>              </select></td>          </tr>          <tr bgcolor="#FFFFFF">             <td height="21" colspan="2">               <div align="center">                 <input type="submit" name="Submit" value="Efetuar Pesquisar">              </div></td>          </tr>        </table></td>    </tr>  </table>  <input name="buscareq" type="hidden" value="1"></form>

valews!!

[elizeu 0]

Muito grato.. valeu mesmo.. havia pesquisado mas coloquei as keywords erradas...

 

t ++

 

 

 

 

Veja http://www.imasters.com.br/forum/index.php...ndpost&p=355133

 

:)

<{POST_SNAPBACK}>