//conexion a la bd
<?php
$conexion = mysql_connect('localhost', 'adminf12', 'OnGTA2L');
mysql_select_db('fldm');
?>
<form id="form1" name="form1" method="post" action="">
<p>Edad
<label for="fecha"></label>
<input name="fecha" type="text" id="fecha" size="10" maxlength="4" />
Areas de Experiencia
<select name="area" id="area">
<option selected="selected">Áreas</option>
<option value="Mercantil">Mercantil</option>
<option value="Penal">Penal</option>
<option value="Laboral">Laboral</option>
<option value="Fiscal">Fiscal</option>
<option value="Amparo">Amparo</option>
<option value="Civil">Civil</option>
<option value="Otros">Otros</option>
</select>
Sexo
<label for="genero"></label>
<select name="genero" id="genero">
<option>Seleccione una opción</option>
<option value="Femenino">Hombre</option>
<option value="Femenino">Mujer</option>
</select>
Status academico
<select name="status" id="status">
<option selected="selected">Seleccione una opción</option>
<option value="Estudiante">Estudiante</option>
<option value="Pasante">Pasante</option>
<option value="Titulado">Titulado</option>
</select>
<input type="submit" name="cmdBuscar" id="cmdBuscar" value="Buscar" />
</p>
</form>
<?php
if (isset($_POST['cmdBuscar'])){
//if($_POST[selano]=="Todos")
//$Sql = "SELECT * FROM tesis ORDER BY te_ano ASC;";
//else
//$Sql = "SELECT * FROM tesis WHERE te_ano = '$_POST[selano]' ORDER BY te_ano ASC;";
$Sql = "SELECT * FROM bolsadetrabajo WHERE fecha_nac = '$_POST[fecha]' AND area_interes1= '$_POST[area]' AND genero= '$_POST[genero]' AND status_academico='$_POST[status] ;";
$result = mysql_query($Sql);
printf("<table width=100%% border=1 bordercolor=#800000 cellspacing=0 cellpadding=0>
<tr>
<td class='numtxt'>Matrícula</td>
<td class='numtxt'>Nombre</td>
<td class='numtxt'>A. Paterno</td>
<td class='numtxt'>A. Materno</td>
<td class='numtxt'>Fecha de Nacimiento</td>
<td class='numtxt'>E-mail</td>
<td class='numtxt'>Tel</td>
<td class='numtxt'>Celular</td>
<td class='numtxt'>Género</td>
<td class='numtxt'>Areas de Interes</td>
<td class='numtxt'>Estatus Académico</td>
<td class='numtxt'>Maestría</td>
<td class='numtxt'>E. Maestría</td>
<td class='numtxt'>Otros Estudios</td>
<td class='numtxt'>Experiencia Laboral</td>
<td class='numtxt'>Area de Experiencia</td>
<td class='numtxt'>Idioma</td>
<td class='numtxt'>Dominio</td>
<td class='numtxt'>Ocupación Laboral</td>
</tr>");
while($row=mysql_fetch_array($result))
{
printf("<tr>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
</tr>",$row['mat'],$row['nombre'],$row['ap_paterno'], $row['ap_materno'], $row['fecha_nac'], $row['email'], $row['tel_casa'], $row['celular'], $row[''], $row[''], $row[''], $row[''], $row[''], $row[''], $row[''], $row[''], $row[''], $row[''], $row[''], $row[''], $row[''], $row[''], $row[''], $row['']);
}
mysql_free_result($result);
printf("</table>");}
?>