thanks for the reply
not sure I understand your response. here is example of the code I have that
RS1 - txt11 - txt12 - txt13 - txt14 - txt15
RS2 - txt21 - txt22 - txt23 - txt24 - txt25
RS3 - txt31 - txt32 - txt33 - txt34 - txt35
RS4 - txt41 - txt42 - txt43 - txt44 - txt45
RS5 - txt51 - txt52 - txt53 - txt54 - txt55
RS6 - txt61 - txt62 - txt63 - txt64 - txt65
<table>
<tr>
<th>Service Table</th>
</tr>
<tr>
<th> </th>
<th>serv_title 1</th>
<th>serv_title 2</th>
<th>serv_title 3</th>
<th>serv_title 4</th>
<th>serv_title 5</th>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_RS1['serv'];?></td>
<td><?php echo $row_RS1['serv1'];?></td>
<td><?php echo $row_RS1['serv2'];?></td>
<td><?php echo $row_RS1['serv3'];?></td>
<td><?php echo $row_RS1['serv4'];?></td>
<td><?php echo $row_RS1['serv5'];?></td>
</tr>
<?php } while ($row_RS1 = mysql_fetch_assoc($RS1)); ?>
</table>
here is example of what I am looking to do but this won't work as you can only read the table once (it seems)
RS1 RS2 RS3 RS4 RS5 RS6
txt11 txt21 txt31 txt41 txt51 txt61
txt12 txt22 txt32 txt42 txt52 txt62
txt13 txt22 txt33 txt43 txt53 txt63
txt14 txt22 txt34 txt44 txt54 txt64
txt15 txt22 txt35 txt45 txt55 txt65
<table>
<tr>
<th>Service Table</th>
</tr>
<tr>
<th> </th>
<?php do { ?>
<th><?php echo $row_RS1['serv'];?></th>
<?php } while ($row_RS1 = mysql_fetch_assoc($RS1)); ?>
</tr>
<tr>
<th>serv title1</th>
<?php do { ?>
<th><?php echo $row_RS1['serv1'];?></th>
<?php } while ($row_RS1 = mysql_fetch_assoc($RS1)); ?>
</tr>
<tr>
<th>serv title2</th>
<?php do { ?>
<th><?php echo $row_RS1['serv2'];?></th>
<?php } while ($row_RS1 = mysql_fetch_assoc($RS1)); ?>
</tr>
<tr>
<th>serv title3</th>
<?php do { ?>
<th><?php echo $row_RS1['serv3'];?></th>
<?php } while ($row_RS1 = mysql_fetch_assoc($RS1)); ?>
</tr>
<tr>
<th>serv title4</th>
<?php do { ?>
<th><?php echo $row_RS1['serv4'];?></th>
<?php } while ($row_RS1 = mysql_fetch_assoc($RS1)); ?>
</tr>
<tr>
<th>serv title5</th>
<?php do { ?>
<th><?php echo $row_RS1['serv5'];?></th>
<?php } while ($row_RS1 = mysql_fetch_assoc($RS1)); ?>
</tr>
</table>