javascript 2d array

[jackvull]

I'm trying to create a javascript 2d array that looks just like a table in SQL server.
Only problem is that the code below only seems to print out 5 rows. ANy ideas on the problem?

<script language = "javascript" type="text/javascript">
var structure = new Array();
structure[0] = new Array(150);
structure[0,0] = 3;
structure[0,1] = "SY400";
structure[0,2] = "SY410";
structure[0,3] = "SY414";
structure[0,4] = "ZACY";
structure[1,0] = 5;
structure[1,1] = "SY600";
structure[1,2] = "SY610";
structure[1,3] = "SY610";
structure[1,4] = "ZALY";
structure[2,0] = 3;
structure[2,1] = "SY400";
structure[2,2] = "SY410";
structure[2,3] = "SY410";
structure[2,4] = "ZAVI";
structure[3,0] = 4;
structure[3,1] = "SY300";
structure[3,2] = "SY340";
structure[3,3] = "SY344";
structure[3,4] = "ZBBC";
structure[4,0] = 1;
structure[4,1] = "SY700";
structure[4,2] = "SY700";
structure[4,3] = "SY700";
structure[4,4] = "ZBDX";
structure[5,0] = 4;
structure[5,1] = "SY300";
structure[5,2] = "SY340";
structure[5,3] = "SY345";
structure[5,4] = "ZBFP";
structure[6,0] = 3;
structure[6,1] = "SY400";
structure[6,2] = "SY440";
structure[6,3] = "SY440";
structure[6,4] = "ZBHX";
structure[7,0] = 2;
structure[7,1] = "SY100";
structure[7,2] = "SY120";
structure[7,3] = "SY123";
structure[7,4] = "ZBIA";
structure[8,0] = 2;
structure[8,1] = "SY100";
structure[8,2] = "SY110";
structure[8,3] = "SY111";
structure[8,4] = "ZBKM";
structure[9,0] = 5;
structure[9,1] = "SY600";
structure[9,2] = "SY630";
structure[9,3] = "SY630";
structure[9,4] = "ZBNA";
structure[10,0] = 5;
structure[10,1] = "SY600";
structure[10,2] = "SY630";
structure[10,3] = "SY630";
structure[10,4] = "ZBNB";
structure[11,0] = 5;
structure[11,1] = "SY600";
structure[11,2] = "SY630";
structure[11,3] = "SY630";
structure[11,4] = "ZBND";
structure[12,0] = 5;
structure[12,1] = "SY600";
structure[12,2] = "SY630";
structure[12,3] = "SY630";
structure[12,4] = "ZBNE";
structure[13,0] = 5;
structure[13,1] = "SY600";
structure[13,2] = "SY630";
structure[13,3] = "SY630";
structure[13,4] = "ZBNH";
structure[14,0] = 5;
structure[14,1] = "SY600";
structure[14,2] = "SY630";
structure[14,3] = "SY630";
structure[14,4] = "ZBNI";
structure[15,0] = 5;
structure[15,1] = "SY600";
structure[15,2] = "SY630";
structure[15,3] = "SY630";
structure[15,4] = "ZBNP";
structure[16,0] = 5;
structure[16,1] = "SY600";
structure[16,2] = "SY630";
structure[16,3] = "SY630";
structure[16,4] = "ZBNS";
structure[17,0] = 5;
structure[17,1] = "SY600";
structure[17,2] = "SY630";
structure[17,3] = "SY630";
structure[17,4] = "ZBNX";
structure[18,0] = 2;
structure[18,1] = "SY100";
structure[18,2] = "SY120";
structure[18,3] = "SY123";
structure[18,4] = "ZBRA";
structure[19,0] = 4;
structure[19,1] = "SY300";
structure[19,2] = "SY320";
structure[19,3] = "SY327";
structure[19,4] = "ZBRY";
structure[20,0] = 2;
structure[20,1] = "SY100";
structure[20,2] = "SY110";
structure[20,3] = "SY112";
structure[20,4] = "ZBSY";
structure[21,0] = 5;
structure[21,1] = "SY500";
structure[21,2] = "SY540";
structure[21,3] = "SY540";
structure[21,4] = "ZCAM";
structure[22,0] = 5;
structure[22,1] = "SY500";
structure[22,2] = "SY540";
structure[22,3] = "SY540";
structure[22,4] = "ZCBM";
structure[23,0] = 5;
structure[23,1] = "SY600";
structure[23,2] = "SY620";
structure[23,3] = "SY620";
structure[23,4] = "ZCBY";
structure[24,0] = 4;
structure[24,1] = "SY300";
structure[24,2] = "SY340";
structure[24,3] = "SY341";
structure[24,4] = "ZCCM";
structure[25,0] = 1;
structure[25,1] = "SY700";
structure[25,2] = "SY700";
structure[25,3] = "SY700";
structure[25,4] = "ZCCX";
structure[26,0] = 2;
structure[26,1] = "SY100";
structure[26,2] = "SY120";
structure[26,3] = "SY122";
structure[26,4] = "ZCFA";
structure[27,0] = 2;
structure[27,1] = "SY100";
structure[27,2] = "SY150";
structure[27,3] = "SY150";
structure[27,4] = "ZCFI";
structure[28,0] = 2;
structure[28,1] = "SY100";
structure[28,2] = "SY150";
structure[28,3] = "SY150";
structure[28,4] = "ZCFM";
structure[29,0] = 2;
structure[29,1] = "SY100";
structure[29,2] = "SY150";
structure[29,3] = "SY150";
structure[29,4] = "ZCFS";
structure[30,0] = 2;
structure[30,1] = "SY100";
structure[30,2] = "SY150";
structure[30,3] = "SY150";
structure[30,4] = "ZCFY";
structure[31,0] = 4;
structure[31,1] = "SY300";
structure[31,2] = "SY310";
structure[31,3] = "SY312";
structure[31,4] = "ZCHY";
structure[32,0] = 5;
structure[32,1] = "SY500";
structure[32,2] = "SY540";
structure[32,3] = "SY540";
structure[32,4] = "ZCIN";
structure[33,0] = 4;
structure[33,1] = "SY300";
structure[33,2] = "SY340";
structure[33,3] = "SY343";
structure[33,4] = "ZCON";
structure[34,0] = 5;
structure[34,1] = "SY500";
structure[34,2] = "SY540";
structure[34,3] = "SY540";
structure[34,4] = "ZCPD";
structure[35,0] = 4;
structure[35,1] = "SY300";
structure[35,2] = "SY340";
structure[35,3] = "SY344";
structure[35,4] = "ZDDA";
structure[36,0] = 2;
structure[36,1] = "SY100";
structure[36,2] = "SY100";
structure[36,3] = "SY100";
structure[36,4] = "ZDEX";
structure[37,0] = 3;
structure[37,1] = "SY400";
structure[37,2] = "SY420";
structure[37,3] = "SY421";
structure[37,4] = "ZDPY";
structure[38,0] = 3;
structure[38,1] = "SY400";
structure[38,2] = "SY420";
structure[38,3] = "SY421";
structure[38,4] = "ZDTI";
structure[39,0] = 3;
structure[39,1] = "SY400";
structure[39,2] = "SY410";
structure[39,3] = "SY412";
structure[39,4] = "ZDUB";
structure[40,0] = 4;
structure[40,1] = "SY300";
structure[40,2] = "SY320";
structure[40,3] = "SY323";
structure[40,4] = "ZEDY";
structure[41,0] = 3;
structure[41,1] = "SY400";
structure[41,2] = "SY440";
structure[41,3] = "SY440";
structure[41,4] = "ZEGX";
structure[42,0] = 3;
structure[42,1] = "SY400";
structure[42,2] = "SY410";
structure[42,3] = "SY411";
structure[42,4] = "ZEGY";
structure[43,0] = 2;
structure[43,1] = "SY100";
structure[43,2] = "SY120";
structure[43,3] = "SY121";
structure[43,4] = "ZELA";
structure[44,0] = 3;
structure[44,1] = "SY400";
structure[44,2] = "SY410";
structure[44,3] = "SY414";
structure[44,4] = "ZENV";
structure[45,0] = 4;
structure[45,1] = "SY300";
structure[45,2] = "SY340";
structure[45,3] = "SY344";
structure[45,4] = "ZGLC";
structure[46,0] = 4;
structure[46,1] = "SY300";
structure[46,2] = "SY340";
structure[46,3] = "SY344";
structure[46,4] = "ZGLP";
structure[47,0] = 2;
structure[47,1] = "SY100";
structure[47,2] = "SY120";
structure[47,3] = "SY121";
structure[47,4] = "ZGRA";
structure[48,0] = 4;
structure[48,1] = "SY300";
structure[48,2] = "SY340";
structure[48,3] = "SY344";
structure[48,4] = "ZGTA";
structure[49,0] = 5;
structure[49,1] = "SY200";
structure[49,2] = "SY210";
structure[49,3] = "SY210";
structure[49,4] = "ZGWH";
structure[50,0] = 4;
structure[50,1] = "SY300";
structure[50,2] = "SY310";
structure[50,3] = "SY312";
structure[50,4] = "ZHKY";
structure[51,0] = 4;
structure[51,1] = "SY300";
structure[51,2] = "SY320";
structure[51,3] = "SY324";
structure[51,4] = "ZHSY";
structure[52,0] = 4;
structure[52,1] = "SY300";
structure[52,2] = "SY310";
structure[52,3] = "SY312";
structure[52,4] = "ZIMY";
structure[53,0] = 3;
structure[53,1] = "SY400";
structure[53,2] = "SY440";
structure[53,3] = "SY440";
structure[53,4] = "ZINX";
structure[54,0] = 4;
structure[54,1] = "SY300";
structure[54,2] = "SY310";
structure[54,3] = "SY311";
structure[54,4] = "ZIPY";
structure[55,0] = 1;
structure[55,1] = "SY700";
structure[55,2] = "SY700";
structure[55,3] = "SY700";
structure[55,4] = "ZITX";
structure[56,0] = 4;
structure[56,1] = "SY300";
structure[56,2] = "SY320";
structure[56,3] = "SY321";
structure[56,4] = "ZJER";
structure[57,0] = 4;
structure[57,1] = "SY300";
structure[57,2] = "SY320";
structure[57,3] = "SY321";
structure[57,4] = "ZJRY";
structure[58,0] = 2;
structure[58,1] = "SY100";
structure[58,2] = "SY120";
structure[58,3] = "SY121";
structure[58,4] = "ZLAA";
structure[59,0] = 4;
structure[59,1] = "SY300";
structure[59,2] = "SY320";
structure[59,3] = "SY321";
structure[59,4] = "ZLBB";
structure[60,0] = 4;
structure[60,1] = "SY300";
structure[60,2] = "SY320";
structure[60,3] = "SY325";
structure[60,4] = "ZLCC";
structure[61,0] = 4;
structure[61,1] = "SY300";
structure[61,2] = "SY340";
structure[61,3] = "SY347";
structure[61,4] = "ZLEI";
structure[62,0] = 4;
structure[62,1] = "SY300";
structure[62,2] = "SY320";
structure[62,3] = "SY320";
structure[62,4] = "ZLMX";
structure[63,0] = 3;
structure[63,1] = "SY400";
structure[63,2] = "SY410";
structure[63,3] = "SY415";
structure[63,4] = "ZLRC";
structure[64,0] = 4;
structure[64,1] = "SY300";
structure[64,2] = "SY320";
structure[64,3] = "SY321";
structure[64,4] = "ZMAL";
structure[65,0] = 1;
structure[65,1] = "SY700";
structure[65,2] = "SY700";
structure[65,3] = "SY700";
structure[65,4] = "ZMAX";
structure[66,0] = 4;
structure[66,1] = "SY300";
structure[66,2] = "SY340";
structure[66,3] = "SY342";
structure[66,4] = "ZMCC";
structure[67,0] = 4;
structure[67,1] = "SY300";
structure[67,2] = "SY340";
structure[67,3] = "SY342";
structure[67,4] = "ZMCM";
structure[68,0] = 4;
structure[68,1] = "SY300";
structure[68,2] = "SY340";
structure[68,3] = "SY342";
structure[68,4] = "ZMCP";
structure[69,0] = 2;
structure[69,1] = "SY100";
structure[69,2] = "SY140";
structure[69,3] = "SY140";
structure[69,4] = "ZMCR";
structure[70,0] = 2;
structure[70,1] = "SY100";
structure[70,2] = "SY130";
structure[70,3] = "SY130";
structure[70,4] = "ZMCT";
structure[71,0] = 4;
structure[71,1] = "SY300";
structure[71,2] = "SY360";
structure[71,3] = "SY361";
structure[71,4] = "ZMGX";
structure[72,0] = 4;
structure[72,1] = "SY300";
structure[72,2] = "SY320";
structure[72,3] = "SY321";
structure[72,4] = "ZMJY";
structure[73,0] = 4;
structure[73,1] = "SY300";
structure[73,2] = "SY350";
structure[73,3] = "SY351";
structure[73,4] = "ZMPY";
structure[74,0] = 2;
structure[74,1] = "SY100";
structure[74,2] = "SY120";
structure[74,3] = "SY121";
structure[74,4] = "ZNDA";
structure[75,0] = 2;
structure[75,1] = "SY100";
structure[75,2] = "SY120";
structure[75,3] = "SY121";
structure[75,4] = "ZNDB";
structure[76,0] = 2;
structure[76,1] = "SY100";
structure[76,2] = "SY110";
structure[76,3] = "SY111";
structure[76,4] = "ZNDM";
structure[77,0] = 4;
structure[77,1] = "SY300";
structure[77,2] = "SY340";
structure[77,3] = "SY340";
structure[77,4] = "ZNMX";
structure[78,0] = 4;
structure[78,1] = "SY300";
structure[78,2] = "SY320";
structure[78,3] = "SY327";
structure[78,4] = "ZPMY";
structure[79,0] = 1;
structure[79,1] = "SY700";
structure[79,2] = "SY700";
structure[79,3] = "SY700";
structure[79,4] = "ZPRX";
structure[80,0] = 5;
structure[80,1] = "SY500";
structure[80,2] = "SY500";
structure[80,3] = "SY500";
structure[80,4] = "ZRBX";
structure[81,0] = 4;
structure[81,1] = "SY300";
structure[81,2] = "SY340";
structure[81,3] = "SY347";
structure[81,4] = "ZRDC";
structure[82,0] = 2;
structure[82,1] = "SY100";
structure[82,2] = "SY110";
structure[82,3] = "SY110";
structure[82,4] = "ZRDM";
structure[83,0] = 2;
structure[83,1] = "SY100";
structure[83,2] = "SY120";
structure[83,3] = "SY121";
structure[83,4] = "ZRWA";
structure[84,0] = 2;
structure[84,1] = "SY100";
structure[84,2] = "SY120";
structure[84,3] = "SY123";
structure[84,4] = "ZSCA";
structure[85,0] = 4;
structure[85,1] = "SY300";
structure[85,2] = "SY310";
structure[85,3] = "SY312";
structure[85,4] = "ZSCM";
structure[86,0] = 4;
structure[86,1] = "SY300";
structure[86,2] = "SY310";
structure[86,3] = "SY312";
structure[86,4] = "ZSEM";
structure[87,0] = 4;
structure[87,1] = "SY300";
structure[87,2] = "SY340";
structure[87,3] = "SY341";
structure[87,4] = "ZSFC";
structure[88,0] = 4;
structure[88,1] = "SY300";
structure[88,2] = "SY340";
structure[88,3] = "SY341";
structure[88,4] = "ZSFM";
structure[89,0] = 4;
structure[89,1] = "SY300";
structure[89,2] = "SY340";
structure[89,3] = "SY341";
structure[89,4] = "ZSFS";
structure[90,0] = 4;
structure[90,1] = "SY300";
structure[90,2] = "SY310";
structure[90,3] = "SY312";
structure[90,4] = "ZSKY";
structure[91,0] = 4;
structure[91,1] = "SY300";
structure[91,2] = "SY320";
structure[91,3] = "SY322";
structure[91,4] = "ZSLY";
structure[92,0] = 4;
structure[92,1] = "SY300";
structure[92,2] = "SY310";
structure[92,3] = "SY312";
structure[92,4] = "ZSTM";
structure[93,0] = 4;
structure[93,1] = "SY300";
structure[93,2] = "SY310";
structure[93,3] = "SY312";
structure[93,4] = "ZSTY";
structure[94,0] = 3;
structure[94,1] = "SY400";
structure[94,2] = "SY420";
structure[94,3] = "SY421";
structure[94,4] = "ZSUR";
structure[95,0] = 5;
structure[95,1] = "SY200";
structure[95,2] = "SY240";
structure[95,3] = "SY240";
structure[95,4] = "ZSWI";
structure[96,0] = 4;
structure[96,1] = "SY300";
structure[96,2] = "SY320";
structure[96,3] = "SY326";
structure[96,4] = "ZTEY";
structure[97,0] = 4;
structure[97,1] = "SY300";
structure[97,2] = "SY320";
structure[97,3] = "SY324";
structure[97,4] = "ZTLY";
structure[98,0] = 3;
structure[98,1] = "SY400";
structure[98,2] = "SY430";
structure[98,3] = "SY432";
structure[98,4] = "ZUSA";
structure[99,0] = 5;
structure[99,1] = "SY600";
structure[99,2] = "SY640";
structure[99,3] = "SY640";
structure[99,4] = "ZUVA";
structure[100,0] = 5;
structure[100,1] = "SY600";
structure[100,2] = "SY640";
structure[100,3] = "SY640";
structure[100,4] = "ZUVB";
structure[101,0] = 5;
structure[101,1] = "SY600";
structure[101,2] = "SY640";
structure[101,3] = "SY640";
structure[101,4] = "ZUVE";
structure[102,0] = 5;
structure[102,1] = "SY600";
structure[102,2] = "SY640";
structure[102,3] = "SY640";
structure[102,4] = "ZUVG";
structure[103,0] = 5;
structure[103,1] = "SY600";
structure[103,2] = "SY640";
structure[103,3] = "SY640";
structure[103,4] = "ZUVH";
structure[104,0] = 5;
structure[104,1] = "SY600";
structure[104,2] = "SY640";
structure[104,3] = "SY640";
structure[104,4] = "ZUVI";
structure[105,0] = 5;
structure[105,1] = "SY600";
structure[105,2] = "SY640";
structure[105,3] = "SY640";
structure[105,4] = "ZUVM";
structure[106,0] = 5;
structure[106,1] = "SY600";
structure[106,2] = "SY640";
structure[106,3] = "SY640";
structure[106,4] = "ZUVR";
structure[107,0] = 5;
structure[107,1] = "SY600";
structure[107,2] = "SY640";
structure[107,3] = "SY640";
structure[107,4] = "ZUVT";
structure[108,0] = 5;
structure[108,1] = "SY600";
structure[108,2] = "SY640";
structure[108,3] = "SY640";
structure[108,4] = "ZUVW";
structure[109,0] = 5;
structure[109,1] = "SY600";
structure[109,2] = "SY640";
structure[109,3] = "SY640";
structure[109,4] = "ZUVX";
structure[110,0] = 2;
structure[110,1] = "SY100";
structure[110,2] = "SY140";
structure[110,3] = "SY140";
structure[110,4] = "ZWAR";
structure[111,0] = 3;
structure[111,1] = "SY400";
structure[111,2] = "SY410";
structure[111,3] = "SY413";
structure[111,4] = "ZWET";
structure[112,0] = 4;
structure[112,1] = "SY300";
structure[112,2] = "SY340";
structure[112,3] = "SY346";
structure[112,4] = "ZWOY";
structure[113,0] = 5;
structure[113,1] = "SY200";
structure[113,2] = "SY210";
structure[113,3] = "SY210";
structure[113,4] = "ZWWX";
document.write ("<table>");
document.write(structure.length);
for (i=0;i<structure.length;i++)
{
document.write ("<tr>");
document.write("<td>" + i + "</td>");
document.write("<td>" + structure [i,0] + "</td>");
document.write("<td>" + structure [i,1] + "</td>");
document.write("<td>" + structure [i,2] + "</td>");
document.write("<td>" + structure [i,3] + "</td>");
document.write("<td>" + structure [i,4] + "</td>");
document.write ("</tr>");
}
document.write ("<table>");
</script>

[ceestand]

Did you try transposing the array position numbers? e.g. "document.write("<td>" + structure [0,i] + "</td>");"

[jackvull]

Done with this:

<script language = "javascript" type="text/javascript">
var structure = new Array();

<?
$i = 0;
while ($row = mssql_fetch_assoc($resultStruc )) {
?>
structure[<?echo $i;?>] = [<?echo $row['DivisionID']?>,
"<?echo $row['Symonds Div Level']?>",
"<?echo $row['Symonds Bus Unit Level']?>",
"<?echo $row['Symonds Regional Level']?>",
"<?echo $row['Cost Centre']?>"];
<?
$i++;
}
?>

document.write ("<table>");
for (i = 0; i < structure.length; i++) {
document.write ("<tr>");
document.write("<td>" + i + "</td>");
document.write("<td>" + structure [i] + "</td>");
document.write ("</tr>");
}
document.write ("<table>");
</script>

<script language = "javascript" type="text/javascript">
var structure = new Array();

structure[0] = [3,
"SY400",
"SY410",
"SY414",
"ZACY"];
structure[1] = [5,
"SY600",
"SY610",
"SY610",
"ZALY"];
structure[2] = [3,
"SY400",
"SY410",
"SY410",
"ZAVI"];
structure[3] = [4,
"SY300",
"SY340",
"SY344",
"ZBBC"];
structure[4] = [1,
"SY700",
"SY700",
"SY700",
"ZBDX"];
structure[5] = [4,
"SY300",
"SY340",
"SY345",
"ZBFP"];
structure[6] = [3,
"SY400",
"SY440",
"SY440",
"ZBHX"];
//etc.
document.write ("<table>");
for (i = 0; i < structure.length; i++) {
document.write ("<tr>");
document.write("<td>" + i + "</td>");
document.write("<td>" + structure [i] + "</td>");
document.write ("</tr>");
}
document.write ("<table>");
</script>

...but
What happens, is someone selects division id 3 in a drop down.
I then need to look through the array and change some other drop downs. For example, in the code above I would pick up rows o,2, and 6 and display some of the other options, so the final drop down options would only have ZACY, ZBBC, and ZBXH in them.

e.g.