double drop down list

[chrlow]

 This a difficult task. Hope any one can help me solved the problem.
 I wanna design a double drop down list by importing the info. from databse.
 The first drop down list is showing a list of the table. When some one select a table name, the second drop down list will appear the attribute name. 
 I try using javascript to solve the problem but it cannot work. Because the javascript variable can not use in php variable.
 Thank!

[Anon]

You should be able to use javascript and PHP in conjunction. The PHP code will have to write variables (arrays?) that the JS knows about. Basically your PHP code will dynamically create the JS. Best of luck.

[jjoske]

You where on the right track with javascript. The secert is to load a javascript array dynamically with php. Below a script that I developed for double drop down menus. You will have to hack it a bit to so that you can populate it it from PHP and fit what you need.

<script language="JavaScript">
var subgenera = new Array();
var subtypes =new Array();
subgenera[1]='grunge';
subtypes[1]=1;
subgenera[2]='pop';
subtypes[2]=1;
subgenera[3]='trance';
subtypes[3]=2;
subgenera[4]='pop';
subtypes[4]=3;
var subgeneras=5;changeoptions();

function changeoptions() {

var item=document.CD.genera.selectedIndex+1;
var x=0;
var p=0;
for(i=1;i<subgeneras;i++) {
if (item==subtypes) {
document.CD.subgenera.options[x]=Option(subgenera,value=i);
if ((item==0) & (i==0)) {
p=x;
}
x=x+1;
}
}
document.CD.subgenera.length=x;
document.CD.subgenera.selectedIndex=p;
}
//-->
</script>

<form name="CD">
<select name="genera" onChange="changeoptions()">
<option value=1>rock and roll</option><option value=2>techno</option><option value=3>country</option></select>
</font></td>
</tr>
<tr>
<td width="25%">sub-genera</td>
<td width="75%"><select name="subgenera"></select></td>
</form>

[chrlow]

 Can someone tell me how the javascripts variable can be used as the php variable. 

"After calling the javascript function, I want to use the variable inside the javascript function to be used within php tage <?php >."

Can you guys try to explain to me how it works and the operation? Give me some example because I do not understand. Please show me the correct path. I am appreacite your help. Thank You.
Any site that I can refer to.

[jjoske]

I've got a perl example for the script that I posted before. If you want I can send you a copy of that. Basically you have to dynamically generate the javascript when you generate the rest of the page. You pass the variables back to PHP through a form.

hope this helps.