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..