Select combinados con php

[pasarlocanutas]

continúa...


<legend class="fieldset">Datos a publicar</legend>
<table width="620" border="0" cellspacing="2" cellpadding="0">
<tr><td width="230" align="right" valign="middle"><label>ESPECIALIDAD/Servicio&nbsp;
</label></td><td><select name="especialidad" id="especialidad">
<option value="0" selected="selected"> </option>
<option value="1">Acupuntura</option>
<option value="2">Adicciones/Tratamiento</option>
<option value="3">ALERGOLOG&Iacute;A</option>
<option value="4">Ambulancias</option>
<option value="5">Análisis clínicos</option>
<option value="6">ANESTESIOLOG&Iacute;A</option>
<option value="7">APARATO DIGESTIVO</option>
<option value="8">Asistencia a domicilio</option>
<option value="9">Asociaciones</option>
<option value="10">CARDIOLOG&Iacute;A</option>
<option value="11">Centro Auditivo</option>
<option value="12">Centro de belleza</option>
<option value="13">Centro de día</option>
<option value="14">Centro de dietética</option>
<option value="15">Centro de pilates</option>
<option value="16">Centro de yoga</option>
<option value="17">Certificados médicos</option>
<option value="18">CIRUG&Iacute;A GENERAL</option>
<option value="19">CIRUG&Iacute;A MAXILOFACIAL</option>
<option value="20">CIRUG&Iacute;A ORTOP&Eacute;DICA</option>
<option value="21">CIRUG&Iacute;A PEDI&Aacute;TRICA</option>
<option value="22">CIRUG&Iacute;A PROCTOL&Oacute;GICA</option>
<option value="23">CIRUG&Iacute;A PL&Aacute;STICA Y REPARADORA</option>
<option value="24">CIRUG&Iacute;A VASCULAR</option>
<option value="25">Clínicas del dolor</option>
<option value="26">DERMATOLOG&Iacute;A</option>
<option value="27">DIGESTIVO</option>
<option value="28">ENDOCRINOLOG&Iacute;A/Nutrición</option>
<option value="29">Enfermería</option>
<option value="30">ESTOMATOLOG&Iacute;A</option>
<option value="31">Farmacia</option>
<option value="32">Fisioterapia</option>
<option value="33">GASTROENTEROLOG&Iacute;A</option>
<option value="34">GERIATR&Iacute;A</option>
<option value="35">Gimnasio</option>
<option value="36">GINECOLOG&Iacute;A</option>
<option value="37">HEMATOLOG&Iacute;A</option>
<option value="38">Herbolario</option>
<option value="39">Homeopatía</option>
<option value="40">INMUNOLOG&Iacute;A CL&Iacute;NICA</option>
<option value="41">Logopedia</option>
<option value="42">Masajista</option>
<option value="43">MEDICINA DEPORTIVA</option>
<option value="44">Medicina General</option>
<option value="45">MEDICINA INTERNA</option>
<option value="46">MEDICINA NATURISTA</option>
<option value="47">MICROBIOLOG&Iacute;A</option>
<option value="48">NEFROLOG&Iacute;A</option>
<option value="49">NEUMOLOG&Iacute;A</option>
<option value="50">NEUROCIRUG&Iacute;A</option>
<option value="51">NEUROLOG&Iacute;A</option>
<option value="52">OBSTETRICIA</option>
<option value="53">ODONTOLOG&Iacute;A</option>
<option value="54">OFTALMOLOG&Iacute;A</option>
<option value="55">&Oacute;ptica</option>
<option value="56">Ortopedia</option>
<option value="57">OSTEOPAT&Iacute;A</option>
<option value="58">OTORRINOLARINGOLOG&Iacute;A</option>
<option value="59">Parafarmacia</option>
<option value="60">Pedagogía</option>
<option value="61">Pediatría</option>
<option value="62">Peluquería</option>
<option value="63">Podología</option>
<option value="64">Practicante</option>
<option value="65">Preparación al parto</option>
<option value="66">Psicología</option>
<option value="67">PSIQUIATR&Iacute;A</option>
<option value="68">RADIOLOG&Iacute;A</option>
<option value="69">REHABILITACI&Oacute;N</option>
<option value="70">Residencias</option>
<option value="71">REUMATOLOG&Iacute;A</option>
<option value="72">Sexología</option>
<option value="73">Spa</option>
<option value="74">TOCOGINECOLOG&Iacute;A</option>
<option value="75">TRAUMATOLOG&Iacute;A</option>
<option value="76">UROLOG&Iacute;A</option>
<option value="77">Otros</option>
</select></td></tr>

<tr><td width="230" align="right" valign="middle"><label>Nombre&nbsp;</label></td><td><input name="nombre" type="text" size="60"/>
</td></tr>

<tr><td width="230" align="right" valign="middle"><label>Centro&nbsp;</label></td><td><input name="centro" type="text" size="60"/></td></tr>


<tr><td width="230" align="right" valign="middle"><label>Preferencia identidad&nbsp;</label></td><td>

<input type="radio" name="preferencia" value="1" id="preferencia_0" checked="checked"/>
Nombre
<input type="radio" name="preferencia" value="2" id="preferencia_1" />
Centro</td></tr>

<tr><td width="230" align="right" valign="middle"><label>Provincia&nbsp;</label></td><td>

<select name="provincia">
<option value="0" selected="selected"> </option>
<option value="Las Palmas">Las Palmas</option>
<option value="Santa Cruz de Tenerife">Santa Cruz de Tenerife</option>
</select>

</td></tr>
<tr><td width="230" align="right" valign="middle"><label>Dirección&nbsp;</label></td><td><input name="direccion" type="text" size="60"/> </td></tr>
<tr><td width="230" align="right" valign="middle"><label>Provincia&nbsp;<br/>Isla&nbsp;<br/>Localidad&nbsp;</label></td><td>

<?php include("Mysql.php");

$db = new MySQL();
$consulta_pais = $db->consulta("SELECT * FROM pais");
echo '<html>';
echo '<form method="post" action="">';

$pais=$_POST['pais'];
$departamentos=$_POST['departamentos'];
$distrito=$_POST['distrito'];

echo '<select name="pais" onChange="submit()" >';
if ($db->num_rows($consulta_pais)>0){
echo "<option value= '$pais'>".$pais.'</option>';
while ($resultado=$db->fetch_array($consulta_pais)){ echo '<option value= "'.$resultado['pais'].'">'.$resultado['pais'].'</option>';
}
}
echo '</select>';
echo '<br>';

$consulta_cod_pais = $db->consulta("SELECT idp FROM pais WHERE pais='$pais'");
$resultado_cod_pais=$db->fetch_array($consulta_cod_pais);
$cod_pais=$resultado_cod_pais['idp'];
$consulta_departamento = $db->consulta("SELECT * FROM dep where pais_idp='$cod_pais'");


echo '<select name="departamentos" onChange="submit()">';
if ($db->num_rows($consulta_departamento)>0){
echo "<option value= '$departamentos'>".$departamentos.'</option>';
while ($resultado=$db->fetch_array($consulta_departamento)){ echo '<option value= "'.$resultado['departamento'].'">'.$resultado['departamento'].'</option>';
}
}
echo '</select>';
echo '<br>';

$consulta_cod_departamento = $db->consulta("SELECT iddep FROM dep WHERE departamento='$departamentos'");
$resultado_cod_departamento=$db->fetch_array($consulta_cod_departamento);
$cod_departamento=$resultado_cod_departamento['iddep'];
$consulta_distrito = $db->consulta("SELECT * FROM distrito where dep_iddep='$cod_departamento'");


echo '<select name="distrito" onChange="submit()">';
if ($db->num_rows($consulta_distrito)>0){
echo "<option value= '$distrito'>".$distrito.'</option>';
while ($resultado=$db->fetch_array($consulta_distrito)){ echo '<option value= "'.$resultado['distrito'].'">'.$resultado['distrito'].'</option>';
}
}
echo '</select>';
echo '</html>';
echo '</form>';
?>



</td></tr>
<tr><td width="230" align="right" valign="middle"><label>Código Postal&nbsp;</label></td><td><input name="codigopostal" type="text" maxlength="5" size="12"/> </td></tr>