Need To Display In Table Very Urgent

[mirzaali]

Hi All,

I neeed to dispaly the data in html table tag

Query :-select comp,total,funds from table1,
WHICH WIL RETURN 3-RECORDSETS

rs_query(0)
rs_query(1)
rs_query(2)


The 2nd row is retrived from aother query
Query :-select companies from table2 where comp='reliance'

RS_fund(0)


i need to display the recordset in a table .can some one pls help it ASAP.
pls mail me at <removed email - use PM if necessary>




fOR EX:-

Ist rOW:-Reliance
2nd ROW :-RPL
rnL
rnrl
3rRD ROW:-1000
4TH ROW:-333

Ist row ,3rd row and 4th row values are retrived from a single query


CODE:-
[html]
<tr id="COL1" colspan=7 bgcolor="<%=bgCol%>" >
<td width=122px ><font face="" id="COL1" size="2" class="pastandard"><%=rs_query.fields(0)%></font></b></td>
<td width=122px ><font face="" id="COL1" size="2" class="pastandard"><%=rs_FUND.fields(0)%></font></b></td>
<td width=122px ><font face="" id="COL1" size="2" class="pastandard"><%=rs_query.fields(1)%></font></b></td>
<td width=122px ><font face="" id="COL1" size="2" class="pastandard"><%=rs_query.fields(2)%></font></b></td>
</tr>
[/html]
Please help me ASAP i am havng a dead line

[omerbutt]

which platform are you using where from you are displaying the data in a table from the data base or by taking it as a input from the user ....elaborate your question before your expect a reply

[jhardman]

Hi All,

I neeed to dispaly the data in html table tag

Query :-select comp,total,funds from table1,
WHICH WIL RETURN 3-RECORDSETS

rs_query(0)
rs_query(1)
rs_query(2)

Why does this return 3 recordset? or do you mean it returns 3 records?

The 2nd row is retrived from aother query
Query :-select companies from table2 where comp='reliance'

RS_fund(0)
...
CODE:-
[html]
<tr id="COL1" colspan=7 bgcolor="<%=bgCol%>" >
<td width=122px ><font face="" id="COL1" size="2" class="pastandard"><%=rs_query.fields(0)%></font></b></td>
<td width=122px ><font face="" id="COL1" size="2" class="pastandard"><%=rs_FUND.fields(0)%></font></b></td>
<td width=122px ><font face="" id="COL1" size="2" class="pastandard"><%=rs_query.fields(1)%></font></b></td>
<td width=122px ><font face="" id="COL1" size="2" class="pastandard"><%=rs_query.fields(2)%></font></b></td>
</tr>
[/html]
Please help me ASAP i am havng a dead line

This looks good. What part is giving you trouble?

Jared