Hello
Can someone pleas help me !???
I have a folder : images whit this images
0_star_rating.gif
1_star_rating.gif
2_star_rating.gif
3_star_rating.gif
4_star_rating.gif
5_star_rating.gif
and a database whit the name : banner.mdb
Tabel: Banner
BannerID = Auto
Url = Text
LinkNavn = Text
Hits = Number
No_of_ratings = Number
Rating = Number
Total_rate_amount = Number
And a site Default.asp
<html>
<title>Hente data fra database</title>
<head>
</head>
<body>
<ul>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("banner.mdb")
Conn.Open DSN
strSQL = "Select * From Banner Order by Url Desc"
Set rs = Conn.Execute(strSQL)
Do
strNavn = rs("LinkNavn")
strHits = rs("Hits")
strRating = rs("Rating")
strNORating = rs("No_of_ratings")
strLink = "<a href=antalhits.asp?id='" & rs("bannerID") & "'>" & strNavn & "</a> ("& strHits &") <br><img src=images/'"& strRating &"'_star_rating.gif"" width='66' height='14' alt=""" & strRating & " star rating""> Average rating based on " & strNORating & " votes - <a href=""JavaScript:popup('rate_link.asp?id='" & rs("BannerID") & "','rate_site')"" style=""font-size: 12; font-style: italic;"">Rate Link</a>"
Response.Write "<li>" & strLink & "</li>"
rs.MoveNext
Loop While Not rs.EOF
Conn.Close
Set Conn = Nothing
%>
</ul>
</body>
</html>
I cant get se the images om my site !!! if u look at
<img src=images/'"& strRating &"'_star_rating.gif"" width='66' height='14' alt=""" & strRating & " star rating""> Then the &strRating& shut get a number from Rating in my database ex 4 and the show the 4_star_rating.gif images !!!! but i cant get my script to show the images !!???
the script is running at this adress http://212.10.209.239/antalhits/default.asp
can someone help me !??????
Topic Options
Post Options
Thanks(0)
