I have 4 selection boxes on a page.
Select 1 holds the parent data
Select 2 hold data 1 level down from select 1 and so on.
I have it working but have to submit the form for each select change to take effect.
[php]<?php $sql=("SELECT * FROM Somewhere WHERE Parent = '1' ORDER by 'name'"); $parent = mysql_query($sql, $con) or die(mysql_error()); $parent_row = mysql_fetch_assoc($par);
<?php $sql1=("SELECT * FROM Somewhere WHERE Parent = '$select1' ORDER by 'name'"); $parent1 = mysql_query($sql1, $con) or die(mysql_error()); $parent1_row = mysql_fetch_assoc($par);
echo $parent_Row['name']; ?>
echo $parent1_Row['name']; ?>
The above is just an example to give you an idea. Is there a way that the boxes will refresh on change.
I know this can be done with jave but need the information pulling from an sql database.
Does anyone have any suggestions