Drop down box php mysql

[mattkirtley]

Hi,

 

I have an insert script into a database with serveral fields one of them is a drop down box fed from a mysql database, what i need to do is in the next field populate it with a field from the same database driven by the choice from the drop down box

 

?>

            <option value="<?php echo $row_artists['artist_show']?>" ><?php echo $row_artists['artist_show']?></option>

            <?php

} while ($row_artists = mysql_fetch_assoc($artists));

?>

          </select>

 

Any ideas?

 

Many thanks!

[bbaker]

do you mean that you have a drop down list, then once you select an option from the list you want to populate the next input field with data depending on the selected option? You'll need javascript for that.

[mattkirtley]

Ah right, I have been pulling my hair all day trying different quiries!

 

Thanks for that - any ideas where i can find a decent script?