|
|
Cinema
Paradiso A century of cinema... |
|||||||||||||||
|
|
||||||||||||||||
|
<%
//Open Movies DB
DSN = "DSN=kohary-movies";
Conn = Server.CreateObject("ADODB.Connection");
Conn.Open(DSN);
//Create movie_object
sql = "SELECT * from movies order by id";
rs = Server.CreateObject ("ADODB.RecordSet");
rs.Open (sql, Conn, 2,3);
movie_object = new Object ();
temp_counter = 0;
while (! (rs.EOF)){
movie_object[temp_counter] = new Object ();
movie_object[temp_counter].id = String(rs.fields.item("id"));
movie_object[temp_counter].title = String(rs.fields.item("title"));
movie_object[temp_counter].year = String(rs.fields.item("year"));
movie_object[temp_counter].director = String(rs.fields.item("director"));
movie_object[temp_counter].update = String(rs.fields.item("update"));
movie_object[temp_counter].imdb_hyperlink = String(rs.fields.item("imdb_hyperlink"));
rs.move(1);
temp_counter ++;
}
movie_object.qty = (temp_counter);
rs.close;
%>
My Video
Collection On DVD (total titles = <% = movie_object.qty %>): <% //Display list of movies for (i = 0; i < movie_object.qty; i++){ if (movie_object[i].update == "true") {%> **<%} else{%> <%}%> <% = movie_object[i].title %> | <% = movie_object[i].year %> | <% = movie_object[i].director %> <%if (movie_object[i].imdb_hyperlink != "null") {%> | IMDB <%}%><% } %> On VHS videotape (WS denotes widescreen edition): AladdinAnne of Avonlea (TV) Anne of Green Gables (TV) Bambi The Bells of St. Marys Cinderella The Lion King Little Miss Broadway Meet Me in St. Louis Miracle on 34th Street - Les Mayfield (1994) Monty Python's The Meaning of Life The Neverending Story Pretty in Pink The Rescuers Schindler's List (WS) - Steven Spielberg (1993) Sleeping Beauty (WS) - Clyde Geronimi (1959) The Texas Chainsaw Massacre Who Framed Roger Rabbit? - Robert Zemeckis (1988) Misc: Airport |
|||||||||||||||
|
I'm sorry to say that my e-mail has been spammed out by lowlife spammers. I can't provide an e-mail link here, because the spambots will simply invade my newest e-mail addy. You can reach me manually, though - just send your e-mail to mike at kohary dot com (simply turn the bolded text into an e-mail address by inserting the appropriate symbols in the right places). Thanks, and I'm sorry for the inconvenience. |
||||||||||||||||
