Javascript and MySQL

[Gordon Sharpe]

I am not at all familiar with exactly how drop boxes get their information. Below, I have pasted part of a JavaScript from the page I am designing, that contains a 3-level set of drop boxes. In this script at the bottom, it points to the names "General News' and "Technology News". To populate my drop boxes, I need to have that box display a list from an Access database of roughly 200 country names. Selecting one of those names will lead to drop box #2 where there will appear a list of Province/State from another table in that Access database. My question therefore is what scripting do I need there to effect that result? With what do I replace General News and Technology News? Assume for the sake of argument that the database presently resides at c:\Access\database.mdb

var groups=document.isc.example.options.length
var group=new Array(groups)
for (i=0; i<groups; i++)
group=new Array()

group[0][0]=new Option("---Select2---"," ");

group[1][0]=new Option("Now Select This One"," ");
group[1][1]=new Option("JavaScript","47");
group[1][2]=new Option("CSS","46");
group[1][3]=new Option("Ajax","45");

group[2][0]=new Option("Now Select This One"," ");
group[2][1]=new Option("General News","115");
group[2][2]=new Option("Technology News","116");