¡¡¡solucion A Combos Dependientes!!!!

[skywaker]

¡¡¡¡SOLUCION A COMBOS DEPENDIENTES !!!!! (PARTE 4...)

/*select_rs.php*/

<?php

require("jsrsServer.php.inc");
jsrsDispatch( "makeList modelList optionsList" );
/*EMPIEZAN MIS FUNCIONES*/

function empList($serietxt) {
return serializeSql("select IdUser, IdUser as iu from asiganciones where NumSerie='$serietxt'" );
}
/*TERMINAN MIS FUNCIONES*/


function makeList() {
//return serializeSql( "select makeID, makeName from makes order by makeName" );
return serializeSql( "select clave, clave as c2 from dependencias order by nombre" );
}

function modelList( $clave ){
return serializeSql("select Nombre as c1, ClaveDepto as c2 from departamentos where Clave='$clave'");
}

function optionsList( $ClaveDepto ){
return serializeSql2("select nombre, IdUser as c2,Appaterno, Apmaterno from empleados where ClaveDepto='$ClaveDepto'");
}
function serializeSql2( $sql ){
$link = mssql_connect("ARMANDO", "sa", "gamma");
$iddb=mssql_select_db ("inventario",$link);

$result = mssql_query ($sql);
$s = '';
$x = '';
$y = '';
while ($row = mssql_fetch_array($result)) {
$x=trim($row[0])." ".trim($row[2])." ".trim($row[3]);
$y=trim($row[1]);
$s .= ($x.'~'.$y)."|";
}
mssql_close($link);
return $s;
}



function serializeSql( $sql ){
$link = mssql_connect("ARMANDO", "sa", "gamma");
$iddb=mssql_select_db ("inventario",$link);

$result = mssql_query ($sql);
$s = '';
$x = '';
$y = '';
while ($row = mssql_fetch_array($result)) {
$x=trim($row[0]);
$y=trim($row[1]);
$s .= ($x.'~'.$y)."|";
}
mssql_close($link);
return $s;
}

?>
/*TERMINA select_rs.php*/