I am making a online movie tickets booking website and in my index page I have 5 drop down boxes movies, timings, theatre name, date and price. All these drop down boxes use 2 sql tables.
What I need is that the drop down boxes get populated from the databse based on each others value. For eg. the movie name to be populated from database and then the show timing and theatre name based on the movie name.
Please help me as I have searched a lot regarding this but all in vein. It is urgent as I need to submit my project in 10 days.
Thanks in advance.