Ormai ho tratto la mia conclusione dopo circa tre ore, le ho provate veramente tutte! Non sono capace di fare la paginazione! Vi posto tutta la mia pagina, se qualcuno gentilmente mi aiuta (me la fa) la paginazione. Vi prego, sono ormai disperato!

codice:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>home</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
	background-color: #DDF4FF;
}
.Stile7 {
	font-size: 12px;
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-weight: normal;
	font-variant: normal;
}
.Stile1 {	font-size: 10px;
	font-style: normal;
	line-height: normal;
	font-weight: normal;
	font-variant: normal;
}
.Stile2 {font-size: No}
.Stile3 {	font-size: 10px;
	font-style: normal;
	line-height: normal;
	font-weight: normal;
	font-variant: normal;
	font-family: Verdana, Arial, Helvetica, sans-serif;
}
.Stile5 {font-style: normal; line-height: normal; font-variant: normal; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px;}
.Stile9 {font-size: 10px; font-style: normal; line-height: normal; font-weight: bold; font-variant: normal; font-family: Verdana, Arial, Helvetica, sans-serif; }
.Stile11 {
	font-size: 13px;
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-weight: bold;
	font-variant: normal;
	color: #990000;
}
.Stile27 {	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 10px;
	text-decoration: none;
}
a:link {
	color: #990000;
	text-decoration: none;
}
a:visited {
	text-decoration: none;
	color: #990000;
}
a:hover {
	text-decoration: underline;
	color: #0000FF;
}
a:active {
	text-decoration: none;
}
-->
</style></head>
<%
tipo= request("tipo")
%>

<body>
<table width="700"  border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <th align="left" valign="top" scope="col"><table width="100%"  border="0" cellpadding="0" cellspacing="0">
      <tr align="left" valign="bottom">
        <th height="219" colspan="4" scope="col"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="700" height="219" align="middle">
          <param name="movie" value="images/top_int.swf">
          <param name=quality value=high>
          <embed src="images/top_int.swf" width="700" height="219" align="middle" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash"></embed>
        </object></th>
        </tr>
      <tr>
        <th width="24%" height="117" align="left" valign="top" scope="row"><div align="left">[img]images/left_margin1.jpg[/img]</div></th>
        <td width="76%" colspan="3" align="left" valign="middle" bgcolor="#FFFFFF"><div align="justify">
          <table width="95%" height="60"  border="0" align="center" cellpadding="0" cellspacing="0">
            <tr>
              <th colspan="4" align="left" valign="top" scope="col"><div align="justify" class="Stile11"><%=tipo%></div></th>
              </tr>
          </table>
        </div></td>
        </tr>
      <tr>
        <th rowspan="2" align="left" valign="top" background="images/10_pixel.jpg" scope="row"><table width="150"  border="0" align="left" cellpadding="0" cellspacing="0">
          <tr>
            <th height="80" colspan="2" class="Stile7" scope="col"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="150" height="80">
                <param name="movie" value="images/hotel.swf">
                <param name=quality value=high>
                <embed src="images/hotel.swf" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="150" height="80"></embed>
            </object></th>
          </tr>
          <tr>
            <th height="30" colspan="2" class="Stile7" scope="col"></th>
          </tr>
          <tr>
            <th height="90" colspan="2" class="Stile7" scope="col">PRIMO BANNER </th>
          </tr>
          <tr>
            <th height="90" colspan="2" class="Stile7" scope="col">SECONDO BANNER </th>
          </tr>
          <tr>
            <th height="90" colspan="2" class="Stile7" scope="col">TERZO BANNER </th>
          </tr>
          <tr>
            <th height="90" colspan="2" class="Stile7" scope="col">QUARTO BANNER </th>
          </tr>
          <tr>
            <th height="90" colspan="2" class="Stile7" scope="col">QUINTO BANNER </th>
          </tr>
        </table></th>
        <td width="76%" height="519" colspan="3" align="left" valign="top" bgcolor="#FFFFFF"><form action="vis_select.asp" method="post" name="form1" target="_self">
          


            <%
tipo= request("tipo")
dove= request("citta")
If tipo = "Breakfast" then
tipo= "Bed&"&tipo
else
end if
set Conn =Server.CreateObject("ADODB.Connection")
conn.open connstr

sql="select * from alberghi where tipo='"&tipo&"'" 
if dove <> "" then
     sql = sql&" and citta like '%"&dove&"%'"
end if
  set rs=conn.execute(sql)
  
 if not rs.eof then
   do while not rs.eof
     id       =rs("id")
     titolo    =rs("titolo")
     tipo      =rs("tipo")
     citta     =rs("citta")
     descrizione  =rs("descrizione")
	 foto1          =Trim(rs("foto1"))
	
%>
          </p>
          <table width="99%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC">
            <tr align="center" valign="middle" bgcolor="#FFFFFF">
              <td width="19%" rowspan="2" align="left" valign="top" class="Stile1"><div align="left"> [img]../public/<%=foto1%>[/img]</div></td>
              <td width="21%" height="30" align="left" bgcolor="#FFFFFF" class="Stile1"><span class="Stile9"><font color="#000000"><%=titolo%></font></span></td>
              <td width="20%" height="30" align="left" class="Stile5"><font color="#000000"><%=tipo%></font></td>
              <td width="20%" height="30" align="left" class="Stile5"><font color="#000000"><%=citta%></font></td>
            </tr>
            <tr align="center" valign="middle" bgcolor="#FFFFFF">
              <td height="30" colspan="3" align="left" class="Stile1"><div align="justify"><span class="Stile3"><font color="#000000"><font color="#000000"><%=Left(descrizione, 130)%>...</font></font></span></div></td>
            </tr>
            <tr align="center" valign="middle" bgcolor="#FFFFFF">
              <td height="10" colspan="4" align="left" class="Stile1"><span class="Stile3"> </span>
                  <hr>
                  <span class="Stile3"></span> </td>
            </tr>
          </table>
          <%   
     rs.movenext
   loop
%>
          <center>
            

<span class="stilevoci">
              <%   
  else
 %>
            </span></p>
            <table width="288" align="center">
              <tr>
                <td><div align="center"><span class="Stile2"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><font color="#000000">Non esistono strutture nel Data Base</font></font> </span></div></td>
              </tr>
            </table>
            <span class="stilevoci">
            <%
end if
 rs.close
 conn.close 
%>
            </span>
          </center>
          <span class="stilevoci"> </span>
        </form></td>
        <td rowspan="2"></td>
      </tr>
      <tr>
        <td height="19" colspan="3" align="left" valign="top" bgcolor="#FFFFFF"><div align="center"><span class="Stile27">Home - Affittacamere - Ristoranti - Appartamenti

              

              Hotel 1 stella - Hotel 2 stelle - Hotel 3 stelle  - Hotel 4 stelle </span></div></td>
      </tr>
      <tr align="center" valign="bottom">
        <th height="53" colspan="4" scope="row"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="700" height="53">
          <param name="movie" value="images/down.swf">
          <param name=quality value=high>
          <embed src="images/down.swf" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="700" height="53"></embed>
        </object></th>
        </tr>
    </table></th>
  </tr>
</table>
<div align="center"></div>
</body>
</html>
a presto GRAZIE!