Auto-refresh Dynamic Form

[werkkrew]

Okay:

Heres what I want to do:

Im trying to input shows (or have users input) and concert dates for the bands on my website.

I want to have a database with venue information, if a venue has never been entered before, record it...

All recorded venues will be in a drop down list on the "add show" form...if the user selects a venue I want the rest of the venue stuff (location, web address, etc) to fill in so that my assumed stupid users dont try to enter that information in...

How can I do things where the value of a drop down can determine the values of other drop downs and other form data without having clicked a submit button

I have seen this used on car sites where you select a make and it fills in the models automatically...

[trooper]

There are 2 ways of doing this

the first way is (client side scripting) to use javascript so that when the user selects the venue from the dropdown all the other details will be filled in the relevant fields.

The other way (php way / server side) is to firstly select the venue from a drop down then click on a submit. The page would then reload with all the relevant information being present in the correct fields.

When you submit the value in the venue drop down you'd need to go and query your db to get all the other information for that venue.

HTH

GM

[werkkrew]

Id like to do it the server side/php way, but when they click submit, what is the best way for me to have the script the form is posting to differentiate between refreshing data and actually submitting the data?

Id like to have the "add show" form, just one form, not a form that is like step by step like : select venue (submit) date of show (submit) id like to make it a dynamic form, but only use one form

[werkkrew]

I dont know any java, but the first way is actually starting to sound better...can you give me an example of the code for this?