I have a working idea but I'm not sure it's practical real world,
<script type="text/javascript">
function managefirstSelect(value)
{
var firstSelect = document.myform.firstSelect
var secondSelect = document.myform.secondSelect
var thirdSelect = document.myform.thirdSelect
var fourthSelect = document.myform.fourthSelect
var fifthSelect = document.myform.fourthSelect
secondSelect.options.length = 0
thirdSelect.options.length = 0
if(value == "Pink Floyd")
{
secondSelect.options[secondSelect.options.length] = new Option('Please select a venu :')
<?php
$art = $_GET['artists'];
$arts = $db->prepare("SELECT id, artist, date FROM events Where artist = :artists");
$arts->bindValue(':artists', $art);
foreach($arts as $artists):
?>
secondSelect.options[secondSelect.options.length] = new Option('London')
<?php endforeach; ?>
}
}
</script>
So the basic idea would be to use JavaScript to dynamically create options, would it have real world applications? (yes it's not 100% finished yet)