Ciao ragazzi
ho preso uno script per le news e lo sto trasformando per annunci con foto, solo che non mi carica la foto dal database.
nel database, al campo foto1, c'è foto.jpg ma non vedo nulla nel browser.
E' possibile far si che veda l'immagine ma rimpicciolita e che si apra grande col click?
grazie


<%

%>
<html>
<head>
<title>LISTA NEWS</title>
<link rel="stylesheet" href="setting.css" type="text/css">
</head>
<body>
<p align="center"><font face="Verdana" color="#0000FF">LISTA DELLE NEWS</font></p>
<p align="center">
<%
dim cns
set cns = server.createobject("ADODB.Connection")
cns.open "DRIVER={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("/mdb-database/prova.mdb")

dim rsnews, sqlnewws
set rsnews = server.createobject("ADODB.RecordSet")
sqlnewws = "SELECT * FROM news ORDER BY data2 DESC"
rsnews.open sqlnewws, cns, 3, 3

if rsnews.eof then
%>


</p>
<p align="center"><font size="2" face="Verdana">SPIACENTE, Nessuna News per il Momento!!!</font>
<%
else

do while not rsnews.eof
%>


<table width="600" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td></td>
<td></td>
</tr>
<tr>
<td>Rilasciata il:</td>
<td></td>
</tr>
<tr>
<td><font size="2">
<% = rsnews("data") %>
</font></td>
<td></td>
</tr>
<tr>
<td><font face="verdana" size="2">
<% = rsnews("titolo") %>
</font></td>
<td></td>
</tr>
<tr>
<td><font face="verdana" size="2">
<% = rsnews("testo") %>
</font></td>
<td></td>
</tr>
<tr>
<td><font face="verdana" size="2"><img src="<%=foto1%>
</font>
</td>
</tr>
</table>

</center>
</div>

<%
if session("login") = "Admin" then
%>
<font face="verdana" size="1">
[/i]</font></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
</tr>
<tr>
<td>">CANCELLA ">MODIFICA </td>
<td></td>
</tr>
</table>
<tr>
<td rowspan="3" width="28%" valign="top">

<font size="1" face="Verdana">
<font size="2"></font>
</td>
<td width="72%">
<font face="verdana" size="2">
</font>
</td>
</tr>
<tr>
<td style="padding-bottom: 6"><font face="verdana" size="2">
</font></td>
</tr>
<tr>
<td width="72%" style="padding-bottom: 6">

[/b]</font>
<%
end if
%><%
rsnews.movenext
loop

end if
%>
</body>
</html>