listas dependientes en php

[felipec]

no te preocupes ya lo resolvi con este codigo


aqui lo subo por si a alguien lo puede ayudar



<?

$stdout ="";

$stdout.="<form name=\"envio\">\n";
//************************************************** ***********************//
$stdout.=" <select name='programa' onChange='UpdateRamos();'>\n";
$stdout.=" <option>-------------------------------</option>\n";
$stdout.=" <option>-------------------------------</option>\n";
$stdout.=" <option>-------------------------------</option>\n";

$stdout.=" </select>\n";

//************************************************** ************************//


//************************************************** **************************//
$stdout.=" <select name='ramo'>\n";
$stdout.=" <option>-------------------------------</option>\n";
$stdout.=" <option>-------------------------------</option>\n";
$stdout.=" <option>-------------------------------</option>\n";
$stdout.=" <option>-------------------------------</option>\n";
$stdout.=" <option>-------------------------------</option>\n";
$stdout.=" <option>-------------------------------</option>\n";
$stdout.=" </select>\n";
//************************************************** ***************************
$stdout.="</form>";

//************************************************** ************************************//


$stdout.="<script TYPE=\"text/javascript\" LANGUAGE=\"JavaScript\">\n";

$result=mysql_query ("SELECT id_programa, nombre FROM programas ORDER BY id_programa");
$total=mysql_num_rows($result);
$i=0;
$text1 = "Programasdesc = new Array(";
$text2 = "Programas = new Array(";

$text1.= "\"Elija una programa\",";
$text2.= "\"none\",";
while ($dat=mysql_fetch_row($result))
{
if ($i!=0)
{
$text1.=", ";
$text2.=", ";
}
$text1.= "\"$dat[1]\"";
$text2.= "\"$dat[0]\"";
$i=1;
}
$text1.=")\n";
$text2.=")\n";

$stdout.= $text1;
$stdout.= $text2;

$stdout.="Ramos = new Object();\n";
$stdout.="Ramosdesc = new Object();\n";
$stdout.="Ramos[\"none\"]= new Array(\"none\");\n";
$stdout.="Ramosdesc[\"none\"]= new Array(\"Elija una Ramo\");\n";

$result=mysql_query ("SELECT id_programa, nombre FROM programas ORDER BY id_programa");
$total=mysql_num_rows($result);
for ($i=0;$i<$total;$i++)
{
$dat=mysql_fetch_row($result);
$padre=$dat[1];
$id_padre=$dat[0];

$text1 = "Ramos[\"$id_padre\"] = new Array(";
$text2 = "Ramosdesc[\"$id_padre\"] = new Array(";
$k=0;

$result2=mysql_query ("SELECT id_ramo, nombre FROM ramos WHERE id_programa='$id_padre' ORDER BY nombre");
while ($datos=mysql_fetch_row($result2))
{
if ($k!=0)
{
$text1.=", ";
$text2.=", ";
}
$text1.= "\"$datos[0]\"";
$text2.= "\"$datos[1]\"";
$k=1;

}

$text1.=");\n";
$text2.=");\n";

$stdout.= "$text1";
$stdout.= "$text2\n";
}

$stdout.= " for (i=0;i<Programas.length;i++) document.forms['envio'].elements[\"programa\"][i] = new Option(Programasdesc[i], Programas[i]);\n";
$stdout.= " document.forms['envio'].elements[\"programa\"].selectedIndex = 0;\n";


$stdout.= " function UpdateRamos() {\n";
$stdout.= " document.forms['envio'].elements[\"ramo\"].length=0;\n";
$stdout.= " country = document.forms['envio'].elements[\"programa\"];\n";
$stdout.= " ccode = new String(country.options[country.selectedIndex].value);\n";

$stdout.= " if (Ramos[ccode]) {\n";
$stdout.= " document.forms['envio'].elements[\"ramo\"][0] = new Option(Ramosdesc[ccode][0], Ramos[ccode][0], 1, 1);\n";
$stdout.= " for (i=1;i<Ramos[ccode].length;i++) document.forms['envio'].elements[\"ramo\"][i] = new Option(Ramosdesc[ccode][i], Ramos[ccode][i]);\n";
$stdout.= " }\n";
$stdout.= " }\n";
$stdout.= " UpdateRamos();\n";
$stdout.= "</script>\n";



echo "$stdout";
?>