Step 5 : More, more, MORE!
So you want more than
1 column eh? Well simply add a bit more code to the While statement.
<table
border=1><tr><td><strong>Addresses</strong></td><td><strong>City</strong></tr>
<% While Not RecordSet1.EOF
Response.Write("<tr><td>")
%><%=(Recordset1.Fields.Item("Address").Value)%><%
Response.Write("</td><td>") 'Don't Finish the row
yet
%><%=(Recordset1.Fields.Item("City").Value)%><%
'Put in a column
with some
'more data
RecordSet1.MoveNext
Wend
%> </td></tr></table>
|
If you know your HTML,
you see that we didn't end the row quite yet, we added another column and
placed the city value there, simple, and it looks like this: