Help displaying results in HTML table!
Posted: Tue Jul 16, 2002 8:18 pm
Can someone help a lost newbie! I am trying to display my query results in an HTML table and I can't seem to get it right! I would like to display my information whereas a new table is created for each new category. I can't get this to work at all. The following code doesn't give me what I want. It just lumps everything together. Can someone offer some/any guidance at all on how I can have a new table start over when $ratp_Prod_Title changes?
<DIV ALIGN="CENTER">
<TABLE BORDER="1" WIDTH="90%" CELLPADDING="2">
<TR>
<?php
while(odbc_fetch_row($odbc_rs)) {
$ratc_Class_Notes=odbc_result($odbc_rs,3);
$ProdID=odbc_result($odbc_rs,4);
$ratp_Prod_Title=odbc_result($odbc_rs,5);
$ratp_Prod_Info=odbc_result($odbc_rs,6);
$ratp_Prod_Notes=odbc_result($odbc_rs,7);
$ratd_Sort_Order=odbc_result($odbc_rs,8);
$ratd_Column01=odbc_result($odbc_rs,9);
$ratd_Column02=odbc_result($odbc_rs,10);
$ratd_Column03=odbc_result($odbc_rs,11);
$ratd_Column04=odbc_result($odbc_rs,12);
$ratd_Column05=odbc_result($odbc_rs,13);
$ratd_Column06=odbc_result($odbc_rs,14);
$ratd_Column07=odbc_result($odbc_rs,15);
$ratd_Column08=odbc_result($odbc_rs,16);
$ratd_Column09=odbc_result($odbc_rs,17);
$ratd_Column10=odbc_result($odbc_rs,18);
$ratd_Notes=odbc_result($odbc_rs,19);
$Rate_Prod_Id=odbc_result($odbc_rs,21);
?>
<TD><?php echo $ratp_Prod_Title;?></TD>
<TD><?php echo $ratp_Prod_Info;?></TD>
</tr>
<tr>
<?php
echo "<TD>$ratd_Column01</TD>";
echo "<TD>$ratd_Column02</TD>";
echo "<TD>$ratd_Column04</TD>";
echo "<TD>$ratd_Column05</TD>";
echo "<TD>$ratd_Column03</TD>";
}
?>
</tr>
</TABLE>
</DIV>
<DIV ALIGN="CENTER">
<TABLE BORDER="1" WIDTH="90%" CELLPADDING="2">
<TR>
<?php
while(odbc_fetch_row($odbc_rs)) {
$ratc_Class_Notes=odbc_result($odbc_rs,3);
$ProdID=odbc_result($odbc_rs,4);
$ratp_Prod_Title=odbc_result($odbc_rs,5);
$ratp_Prod_Info=odbc_result($odbc_rs,6);
$ratp_Prod_Notes=odbc_result($odbc_rs,7);
$ratd_Sort_Order=odbc_result($odbc_rs,8);
$ratd_Column01=odbc_result($odbc_rs,9);
$ratd_Column02=odbc_result($odbc_rs,10);
$ratd_Column03=odbc_result($odbc_rs,11);
$ratd_Column04=odbc_result($odbc_rs,12);
$ratd_Column05=odbc_result($odbc_rs,13);
$ratd_Column06=odbc_result($odbc_rs,14);
$ratd_Column07=odbc_result($odbc_rs,15);
$ratd_Column08=odbc_result($odbc_rs,16);
$ratd_Column09=odbc_result($odbc_rs,17);
$ratd_Column10=odbc_result($odbc_rs,18);
$ratd_Notes=odbc_result($odbc_rs,19);
$Rate_Prod_Id=odbc_result($odbc_rs,21);
?>
<TD><?php echo $ratp_Prod_Title;?></TD>
<TD><?php echo $ratp_Prod_Info;?></TD>
</tr>
<tr>
<?php
echo "<TD>$ratd_Column01</TD>";
echo "<TD>$ratd_Column02</TD>";
echo "<TD>$ratd_Column04</TD>";
echo "<TD>$ratd_Column05</TD>";
echo "<TD>$ratd_Column03</TD>";
}
?>
</tr>
</TABLE>
</DIV>