Muchisimas gracias por responder. Lo que me decis es perfecto, lo he probado, y me pasa que al elegir uno de los autores me despliega toda la base de datos, indudablemente estoy haciendo algo mal.
Espero no ser muy molesta.
Te escribo todo el codigo.
<div class="contentT">
<form name="form1" method="post" action="">
<table width="450" border="0" align="center" cellpadding="5" cellspacing="5" bordercolor="#000033" bgcolor="#E8ECD1" >
<tr>
<td width="86" height="30" align="left" valign="middle" ><strong>Idioma:</strong></td>
<td width="236" height="30" align="right" valign="middle" >
<div align="right"><strong>
<select name="selIdioma" class="navigation" id="selIdioma">
<option>--------------------------Seleccionar-------------------------</option>
<option value="1">Español</option>
<option value="2">Ingles</option>
<option value="3">Portugues</option>
<option value="4">Turco</option>
<option value="5">Arabe</option>
<option value="6">Ingles-Español</option>
<option value="7">Ingles-Arabe</option>
<option value="8">Español-Arabe</option>
<?php
$tablaidioma = mysql_query("SELECT DISTINCT idioma FROM biblioteca ORDER BY idIdioma ASC");
while ($registroidioma = mysql_fetch_array($tablaidioma)) {
?>
<?php
}
mysql_free_result($tablaidioma);
?>
</select>
</strong></div></td>
</tr>
<tr>
<td height="30" align="left" valign="middle"><strong>Titulo:</strong></td>
<td width="236" height="30" align="right" valign="middle" >
<div align="right"><strong>
<select name="selTitulo" class="navigation" id="selTitulo">
<option value="-1" selected>--------------------------Seleccionar-------------------------</option>
<?php
$tablatitulos = mysql_query("SELECT * FROM biblioteca ORDER BY codigo ASC");
while ($registrotitulo = mysql_fetch_array($tablatitulos)) {
?>
<option value="<?php echo $registrotitulo['codigo']; ?>">
<?php echo $registrotitulo['titulo']; ?>
</option>
<?php
}
mysql_free_result($tablatitulos);
?>
</select>
</strong></div></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" ><strong>Autor:</strong></td>
<td width="236" height="30" align="right" valign="middle" >
<div align="right"><strong>
<select name="selAutor" class="navigation" id="selAutor">
<option value="-1" selected>--------------------------Seleccionar-------------------------</option>
<?php
$tablautores = mysql_query("SELECT DISTINCT autor FROM biblioteca ORDER BY autor ASC");
while ($registroautor = mysql_fetch_array($tablautores)) {
?>
<option value="<?php echo $registroautor['codigo']; ?>">
<?php echo $registroautor['autor']; ?>
</option>
<?php
}
mysql_free_result($tablautores);
?>
</select>
</strong></div></td>
</tr>
<tr>
<td height="30" align="left" valign="middle"><strong>Tema:</strong></td>
<td width="236" height="30" align="right" valign="middle" >
<div align="right"><strong>
<select name="selTema" class="navigation" id="selTema">
<option>--------------------------Seleccionar-------------------------</option>
<option value="1">Coran</option>
<option value="2">Tefsir</option>
<option value="3">Hadices</option>
<option value="4">Vida del Profeta(saws)</option>
<option value="5">Fiqh</option>
<option value="6">Rumi</option>
<option value="7">Yerrahia</option>
<option value="8">Al Ghazzali</option>
<option value="9">Sufismo</option>
<option value="10">Ibn Arabi</option>
<option value="11">Shia</option>
<option value="12">Al Jilani</option>
<option value="13">Misceláneas</option>
<?php
$tablatema = mysql_query("SELECT DISTINCT tema FROM biblioteca ORDER BY idTema ASC");
while ($registrotema = mysql_fetch_array($tablaidioma)) {
?>
<?php
}
mysql_free_result($tablatema);
?>
</select>
</strong></div></td>
</tr>
<tr>
<td align="left" valign="middle"> </td>
<td align="right" valign="middle" > <input name="cmdBuscar" type="submit" class="busc Estilo1" id="cmdBuscar" value="BUSCAR" align="right"></td>
</tr>
</table>
<div align="center"></div>
</form>
</div>
Muchísimas gracias