Now all data are on the same table.
CREATE TABLE lsd_demo_2 (
rec_id int(11) NOT NULL auto_increment,
parent_id int(11) NOT NULL default '0',
descr varchar(50) collate latin1_bin NOT NULL default '',
PRIMARY KEY (rec_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin;
Items for first (parent) select box parent_id=0. Using the new parameter to set an extra field in where clause parent items are filtered.
To use select box onChange event:
<script type="text/javascript">
Event.observe(window, 'load', initSearch, false);
function initSearch() {
Event.observe('sel_id_3', 'change', dosearch, false);
window.alert('ads');
}
function dosearch(){
var val1, val2, val3;
val1='';
val2='';
val3='';
if( $('sel_id_1')!=null);
val1= $('sel_id_1').value;
if( $('sel_id_2')!=null);
val2= $('sel_id_2').value;
if( $('sel_id_3')!=null);
val3= $('sel_id_3').value;
if( val1!='0' && val2!='0' && val3!='0' )
window.alert("sel1="+val1+"&sel2="+val2+"&sel3="+val3);
}
</script>