1 | 2 |
-------
3 | 4 |
Aparecer no maximo 4 registro..
abaixo meu codigo!
<%
Set conn = Server.CreateObject("adodb.connection")
conn.ConnectionString = "driver=MySQL ODBC 3.51 Driver;server=localhost;uid=dstudium_users;pwd=imfast;database=dstudium_banco"
conn.Open
set rs = Server.CreateObject("adodb.recordset")
sql = "select* from portfolio ORDER BY id DESC"
rs.open sql,conn
while not rs.eof
q=q+1
%>
<td width="160">
<img src="<%response.Write(rs("img"))%>" width="54" height="45" border="1" /><br />
<%response.Write(rs("cliente"))%><br>
<%response.Write(rs("ano"))%><br>
<a href="<%response.Write(rs("link"))%>"><%response.Write(rs("link"))%></A>
<%
if q=2 then
%> </td></tr>
<%
q=0
end if
rs.movenext
wend
%>Só que n ao ta ficando nao sei pq.. ta ficando todo desconfigurado.. antes eu tava usando assim
<table width="320" border="0" cellspacing="0" cellpadding="0">
<%
Set conn = Server.CreateObject("adodb.connection")
conn.ConnectionString = "driver=MySQL ODBC 3.51 Driver;server=localhost;uid=dstudium_users;pwd=imfast;database=dstudium_banco"
conn.Open
set rs = Server.CreateObject("adodb.recordset")
sql = "select* from portfolio ORDER BY id DESC"
rs.open sql,conn
if rs.eof then
%>
<%
Else
i=0
do until rs.eof or i=4
%>
<tr>
<td width="160"><img src="<%response.Write(rs("img"))%>" width="54" height="45" border="1" /><br />
<strong>
<%response.Write(rs("cliente"))%>
</strong><br />
<strong>
<%response.Write(rs("ano"))%>
</strong><br />
<strong><a href="sd">
<%response.Write(rs("link"))%>
</a></strong></td>
<%
rs.movenext
i=i+1
loop
end if
%>
<td width="160"> </td>
</tr>
</table>Soh que saia um em baixo do outro.. e eu quero 2x2
Alguem pode me ajudar.. eu ja procurei no forum e nao achei nada a respeito..
