Need help with dropbox
 

Hey Guys!
I want to add a drop box on my site, containing a list of movie titles. When the person clicks on a title, the info of the corresponding movie opens on the same page, under the drop box. I want to do this to avoid having to create one page for each movie.
Problem is, I have no idea how to do this :) . So, can anyone link me to a good tutorial on this? I googled it already, but just found help for more advanced stuff than this!
Thx!
TaviO!

The solution that comes to my mind may not be "the" solution for this problem.

I list it down.

1. A database will have a table that will contain fields (columns) about the information to be displayed. Each row, has to be identified uniquely.
2. Application may be developed to enter the details in the database for each movie and assign a unique id to it.

3. (your page) Will have a drop down combo box which would retrieve details from the database only from the field ("moviename") [JUST an instance]. Each will have an onclick section where the id of the movie is retrieved.

4. A page with a set of fields like "MOVIE NAME:", "RELEASED YEAR:" "DIRECTOR:" , in a tabular format can be developed in ASP, where the filling of information for each would depend on the entry (id) received from the previous page where you retrieved the information on the movie selected. (the code for this could be just below "your page")

Yeah, I guess it's a perfect solution for my problem, thx man!
Now all I have to do is translate all that to code, but that's the easiest part =D
Thanks a lot!
TaviO!

Ummm...so you seem to be pretty perfect to code in ASP :)...Just let me know, which database would you be using..MS-ACCESS / MS-SQL...

I am used to use ACESS most of the time...

I haven't used plain ASP (only ASP.NET, and that was some time ago), but you can do this by querying your database, and spitting out the results. You'll probably need to mix some code directives in with the HTML associated with the ASP to accomplish this (again, not sure how it works in plain ASP).

If you have a set number of categories, and want to allow the user to select from these and only these, you can programatically add them using a repeater (if you just want a side-bar menu or something) or a drop-down list, where you add each category in code. To obtain the categories, you can use SQL's 'SELECT DISTINCT', and specify the column you want distinct values from (ie, the one that holds the 'category' field). This will make it so your menus, drop-down boxes, etc all remain in sync with your database, and only offer options to the user that are valid at any given point in time.