[問題] Table讀資料庫的問題
<%
response.charset = "Big5"
set conn = Server.CreateObject("ADODB.Connection")
conn.open "Driver={Microsoft ODBC for
Oracle};server=cark;uid=web;pwd=gjp4u4"
SQLScript = "select t.StoreNo,t.StoreAlias,substr(t.storeaddress,1,3)
AreaName from car_004 t "&_
"where t.recommandflag='N' order by SORT2 "
set rs = Server.CreateObject("ADODB.Recordset")
rs.open SQLScript,conn,3,3,1
response.write "<ul>"
while not rs.eof
StoreNo = rs("StoreNo")
StoreName = rs("StoreAlias")
AreaName = rs("AreaName")
Counter = 11-(len(StoreName) + len(AreaName))
%>
<table>
<tr>
<td class="advertiser_box"><a
href="showstore.asp?storeno=<%=StoreNo%>"><%=StoreName %></a></td>
</tr>
</table>
<%
rs.MoveNext
wend
response.write "</ul>"
rs.close
conn.close
set rs = nothing
set conn = nothing
%>
(全部程式是這樣)
請問如果我想把原本一列一個資料的方式變成一列2個該怎麼讓資料庫可以照順序讀成兩行?
直接多設一個td會變成兩行都讀成一樣的東西而不是把所有的資料分兩行顯示
想問的是該怎麼讓資料庫可以讀成兩行~謝謝。
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 220.132.152.66
→
02/05 12:38, , 1F
02/05 12:38, 1F
※ 編輯: joyce2267 來自: 220.132.152.66 (02/05 13:15)
推
02/05 14:02, , 2F
02/05 14:02, 2F
→
02/05 14:04, , 3F
02/05 14:04, 3F
→
02/05 14:14, , 4F
02/05 14:14, 4F
討論串 (同標題文章)
完整討論串 (本文為第 1 之 2 篇):