databaseconnection

[andreas57]

i've got a table with domains und an other with email-adresses. there are sevrel email-adresses to one domain. how can i display them?


<b>Emailadressen:</b><br><br>

<table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;>

<tr>
<td width=&quot;10%&quot; valign=&quot;top&quot;><!--mstheme--><font face=&quot;arial, Arial, Helvetica&quot;><font face=&quot;Arial&quot; size=&quot;1&quot;><br>
&nbsp;1.<br>
&nbsp;2.<br>
&nbsp;3.<br>
&nbsp;4.<br>
&nbsp;5.<br>
&nbsp;6.<br>
&nbsp;7.<br>
&nbsp;8.<br>
&nbsp;9.<br>
10.<br>
11.<br>
12.<br>
13.<br>
14.<br>
15.<br>
16.<br>
17.<br>
18.<br>
</td>

<td width=&quot;30%&quot; valign=&quot;top&quot;><!--mstheme--><font face=&quot;arial, Arial, Helvetica&quot;><font face=&quot;Arial&quot; size=&quot;1&quot;><strong>Email:</strong><br><br>
<font COLOR=&quot;#000000&quot;><%=Server.HTMLEncode(rs.Fields(&quot;email&quot.Value & &quot;&quot%><br>
</td>

<td width=&quot;30%&quot; valign=&quot;top&quot;><!--mstheme--><font face=&quot;arial, Arial, Helvetica&quot;><font face=&quot;Arial&quot; size=&quot;1&quot;><strong>User:</strong><br><br>
<font COLOR=&quot;#000000&quot;><%=Server.HTMLEncode(rs.Fields(&quot;user&quot.Value & &quot;&quot%><br>
</td>

<td width=&quot;30%&quot; valign=&quot;top&quot;><!--mstheme--><font face=&quot;arial, Arial, Helvetica&quot;><font face=&quot;Arial&quot; size=&quot;1&quot;><strong>Passwort:</strong><br><br>
<font COLOR=&quot;#000000&quot;><%=Server.HTMLEncode(rs.Fields(&quot;passwort&quot.Value & &quot;&quot%><br>
</td></tr>

</table> [sig][/sig]

 

[andreas57]

could somebody help me please? [sig][/sig]

 

[andreas57]

i thought about puting a loop function in each row so it would jump 18 times forward to see if there is something.

something like this but it doesn't work:

do loop while i<19
i =0
rs.movenext
face=&quot;Arial&quot; size=&quot;1&quot;><strong>Passwort:</strong><br><br>
i=i+1
loop

is there another way to do it? [sig][/sig]