Código PHP:
<?php
mysql_select_db($database_database, $database) or die(mysql_error());
$id_edo=$_POST['id_edo'];
$id_mun=$_POST['id_mun'];
$id_nuc=$_POST['id_nuc'];
$id_tipo=$_POST['id_tipo'];
echo "<form action=\"".$_SERVER['PHP_SELF']."\" method=\"POST\">\n\n";
//********************************************************************************
//estado
echo "Estado <select name=\"id_edo\" onChange=\"this.form.submit()\"size=1 maxlength=1 >\n";
echo "<option value=\"\"> Seleccione un Estado </option>\n";
$SQLconsulta_edo="SELECT * FROM cat_edo ORDER BY scenom_edo";
$consulta_edo = mysql_query($SQLconsulta_edo,$database) or die(mysql_error());
While ($registro_edo=mysql_fetch_assoc($consulta_edo)){
if ($id_edo == $registro_edo['sccecve_edo']){
echo "<option value=\"".$registro_edo['sccecve_edo']."\" selected>".$registro_edo['scenom_edo']."</option>\n";
} else {
echo "<option value=\"".$registro_edo['sccecve_edo']."\">".$registro_edo['scenom_edo']."</option>\n";
}
}
echo "</select>\n\n";
echo "<br><br>";
mysql_free_result($consulta_edo);
//********************************************************************************
// municipio
echo "Municipio <select name=\"id_mun\" onChange=\"this.form.submit()\">\n";
if (!empty($id_edo)){
$SQLconsulta_mun="SELECT * FROM cat_mun WHERE SCMCve_Edo = ".$id_edo; "ORDER BY scnom_mun" ;
$consulta_mun = mysql_query($SQLconsulta_mun,$database) or die(mysql_error());
if (mysql_num_rows($consulta_mun) != 0){
While ($registro_mun=mysql_fetch_assoc($consulta_mun)) {
if ($id_mun == $registro_mun['SCMCve_Mun']){
echo "<option value=\"".$registro_mun['SCMCve_Mun']."\" selected>".$registro_mun['SCMNom_Mun']."</option>\n";
} else {
echo "<option value=\"".$registro_mun['SCMCve_Mun']."\">".$registro_mun['SCMNom_Mun']."</option>\n";
}
}
} else {
echo "<option value=\"\"> No hay Municipios </option>";
}
} else {
echo "<option value=\"\"> Seleccione un Municipio </option>";
}
mysql_free_result($consulta_mun);
echo "</select>\n\n";
echo "<br><br>";
//********************************************************************************
// tipo
echo "Tipo de Propiedad <select name=\"id_tipo\" onChange=\"this.form.submit()\">\n";
echo "<option value=\"\"> Seleccione un tipo </option>\n";
if (!empty($id_mun)){
$SQLconsulta_tipo="select * FROM cat_pro";
$consulta_tipo= mysql_query($SQLconsulta_tipo,$database) or die(mysql_error());
if (mysql_num_rows($consulta_tipo) != 0){
While ($registro_tipo=mysql_fetch_assoc($consulta_tipo)) {
if ($id_tipo == $registro_tipo['sccecve_tipo']){
echo "<option value=\"".$registro_tipo['sccecve_tipo']."\" selected>".$registro_tipo['scenom_tipo']."</option>\n";
} else {
echo "<option value=\"".$registro_tipo['sccecve_tipo']."\">".$registro_tipo['scenom_tipo']."</option>\n";
}
}
} else {
echo "<option value=\"\"> No hay tipos </option>";
}
} else {
echo "<option value=\"\"> Seleccione un tipo </option>";
}
mysql_free_result($consulta_mun);
echo "</select>\n\n";
echo "<br><br>";
//********************************************************************************
// nucleos
echo "Núcleo <select name=\"id_nuc\">\n";
if (!empty($id_tipo)){
$SQLconsulta_nuc="select `SCNCve_Unica`, `SCNNom_Nuc`,`SCNCve_Mun` FROM cat_nuc WHERE SCNTipo_Nuc = ".$id_tipo." AND SCNCve_Mun = ".$id_mun;
$consulta_nuc= mysql_query($SQLconsulta_nuc,$database) or die(mysql_error());
if (mysql_num_rows($consulta_nuc) != 0){
While ($registro_nuc=mysql_fetch_assoc($consulta_nuc)) {
if ($id_nuc == $registro_nuc['SCNTipo_Nuc']){
echo "<option value=\"".$registro_nuc['SCNTipo_Nuc']."\" selected>".$registro_nuc['SCNNom_Nuc']."</option>\n ";
} else {
echo "<option value=\"".$registro_nuc['SCNTipo_Nuc']."\">".$registro_nuc['SCNNom_Nuc']."</option>\n";
}
}
} else {
echo "<option value=\"\"> No hay Nucleos </option>";
}
} else {
echo "<option value=\"\"> *Seleccione un Municipio </option>";
}
mysql_free_result($consulta_mun);
echo "</select>\n\n";
echo "</form>\n";
?>