TaviO!

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!

java_roshan

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")

__________________
Visit: http://www.somaiya.edu

TaviO!

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!

java_roshan

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...

__________________
Visit: http://www.somaiya.edu

TaviO!

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

lectricpharaoh

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.

__________________
A man's knowledge is like an expanding sphere, the surface corresponding to the boundary between the known and the unknown. As the sphere grows, so does its surface; the more a man learns, the more he realizes how much he does not know. Hence, the most ignorant man thinks he knows it all. - L. Sprague de Camp