<script language="JavaScript">
function update(){
<?php
$sqlwrk = "SELECT `Colectores`.`colecNombres`, `Colectores`.`colecApellidos` FROM `Empleados` INNER JOIN `Colectores` ON (`Empleados`.`empEmpleado` = `Colectores`.`colecEmpleadoID`)
WHERE (`Colectores`.`colecActivo` = 'S')ORDER BY `colecApellidos`";
$rswrk = mysql_query($sqlwrk);
$x_vendedoreslist = "";
if ($rswrk)
{
$datawrk = mysql_fetch_array($rswrk);
while (true)
{
if( $datawrk )
{
$x_vendedoreslist .= "\"". $datawrk[0] ." ". $datawrk[1] ."\"";
$x_colectoreslist .= "\"". $datawrk[0] ."\"";
$datawrk = mysql_fetch_array($rswrk);
if( $datawrk )
{
$x_vendedoreslist .= ",";
$x_colectoreslist .= ",";
continue;
}
}
break;
}
}
@mysql_free_result($rswrk);
?>
<?php
echo "var vendedores = new Array(".$x_vendedoreslist.");";
echo "var colectores = new Array(".$x_colectoreslist.");";
?>
var val = document.caja.x_recColectoresID.selectedIndex;
var valco = document.caja.x_recColectoresID.selectedIndex;
document.caja.x_recBeneficiario.value = vendedores[val];
document.caja.x_Codigo.value = colectores[valco];
}
<?php }?>
</script>