Php second-level linkage menu-PHP source code

Ec (2); & lt ;? PhpPHP: & nbsp; pull-down Association data & nbsp; require (& quot; conn. php & quot;); & nbsp; $ resultmysql_query (& quot; SELECT * FROMunitsLEFTJOINusersON (script ec (2); script

// PHP part:
// Get the pull-down linkage data
Require ("conn. php ");
$ Result = mysql_query ("SELECT * FROM units left join users ON (users. unit = units. unid )");
$ Mx = mysql_num_rows ($ result );

For ($ I = 0; $ I <$ mx; $ I ++ ){
$ R = mysql_fetch_array ($ result );
$ Uname = $ r ['uname'];
$ Unid = $ r ['unid'];
$ Usname = $ r ['username'];
$ Usid = $ r ['userid'];

If ($ lasun! = $ Uname ){
$ Java1 = $ java1. "" $ uname ",";
$ Java2 = $ java2. "" $ unid ",";
$ Lasun = $ uname;
If ($ I> 0 ){
$ Java3 = $ java3. "], [";
$ Java4 = $ java4. "], [";
}
} Else {
$ Java3 = $ java3 .",";
$ Java4 = $ java4 .",";
}

$ Java3 = $ java3. "" $ usname "";
$ Java4 = $ java4. "" $ usid "";

}

$ Java1 = "[". substr_replace ($ java1, "",-1). "] n ";
$ Java2 = "[". substr_replace ($ java2, "",-1). "] n ";
$ Java3 = "[[". $ java3. "] n ";
$ Java4 = "[[". $ java4. "] n ";



// Javascript part
?>