Dynamic image and text slideshow: text

Dynamic image and text slideshow

I give double points to the accepted solution!!

Can anyone help me out with creating a vertical slideshow with images from a database which would need to have to following specs:
- database driven (ASP if possible or combination with other script)
- vertically show 3 images, top and bottom faded slightly and the middle one highlighted some way
- the middle one also should be clickable to link to a detail page (ASP)
- next to the middle image I'd like to see a brief description of the image (text from database as well)

This may be a commercial solution as well (if not too expensive)

I give double points to the accepted solution!!

Instant Access to this Solution

Plus...

30 Day FREE access, no risk, no obligation

Collaborate with the world's top tech experts

Unlimited access to our exclusive solution database

Never be left without tech help again

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

"The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.

"Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin

"Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.

Screenshot of Experts Exchange Knowledgebase

Need individual assistance?

Our experts are ready to help.

If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.

Want to learn from the best?

Read articles from industry experts.

Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.

Working on a long term project?

Store your work and research.

Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.

Join the Community

Give a Little. Get a Lot.

Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.

woow, very fast response.

i'll post the code here to make every body get use of it.

database:
=======

create an access database file. name it Images.mdb

creat a table called Image and fill in these data.

ImgID      ImgLoc      ImgDesc
1      1.jpg      one
2      2.jpg      two
3      3.jpg      three
4      4.jpg      four
5      5.jpg      five
6      6.jpg      six
7      7.jpg      seven
8      8.jpg      eight
9      9.jpg      nine
10      10.jpg      ten

the asp file should look like:

<%@ Language=VBScript %>

<html>
<head>
<meta name="GENERATOR" Content="Microsoft Visual Studio.NET 7.0">
</head>
<body>

<%
            Response.Write("&")
            set conn=Server.CreateObject("ADODB.Connection")

            conn.Open "DRIVER={SQL Server};SERVER=CDW2P-HIT8065;UID=sa;PWD=;DATABASE=kanary"
            If conn.errors.count = 0 Then
                  'Response.Write "Connected OK"
            End If
            set rs = Server.CreateObject("ADODB.recordset")
            rs.Open "SELECT UserName,value1,value2 FROM Users;", conn
            counter=1
            do until rs.EOF

                  for each x in rs.Fields
                  Response.Write(x.name)&counter
                  Response.Write("=")
                  Response.Write(x.value)
                  Response.Write("&")

                  next

            counter=counter+1
            rs.MoveNext
            loop

            rs.close
            conn.close
            if Request.Form("test") <>"" then
                  Response.Write "test2="&Request.Form("test")

            end if
            Response.Write "&"
%>

</body>
</html>

and the flash should look like:

myData = new LoadVars();
myData.source = "http://localhost/500Points/ASPImage.asp";
myData.onLoad = function() {
      ImageCounter = this.ImgCount;
      ImageLocs = new Array();
      ImageDesc = new Array();
      for (k=1; k<=this.ImgCount; k++) {
            ImageLocs[k] = this["ImgLoc"+k];
            ImageDesc[k] = this["ImgDesc"+k];
      }
};
myData.load(myData.source);

Question

Dynamic image and text slideshow

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

text

Adobe Dreamweaver

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Need individual assistance?

Our experts are ready to help.

Want to learn from the best?

Read articles from industry experts.

Working on a long term project?

Store your work and research.

What Makes Experts Exchange Unique?

Trusted by the world's most respected brands.

Faithfully serving IT professionals since 1996.

Related Solutions

Free Tech Articles

Cloud Class Webinars

Join the Community

Give a Little. Get a Lot.

Answers

3 Ways to Join

The Experts

The Experts

Testimonials

Testimonials

Testimonials

Business Clients

Business Clients

In the Press

In the Press

In the Press