Use Data as column header in table?

Hi there, I have created a DA page to show results of a small table containing Name,Month, Cases as such:

<table border="1" cellpadding="1" cellspacing="1">
   <thead>
		<tr>
    <th scope="col">Name</th>
    <th scope="col">Month</th>
    <th scope="col">Cases</th>    
  </tr>
   </thead>
  <?php do { ?>
  <tbody>
    <tr>
      <td><?php echo $row_rsChart2['ContactFullName']; ?></td>
      <td><?php echo $row_rsChart2['Month']; ?></td>
      <td><?php echo $row_rsChart2['Cases']; ?></td>
    </tr>
    </tbody>
    <?php } while ($row_rsChart2 = mysql_fetch_assoc($rsChart2)); ?>
</table>

Is it possible I could use the month columns as a header,displaying Jan, Feb, March etc from left to right in column header and cases for each month as data?

Jan - Feb - Mar
User1 100 47 89
user2 86 67 134

With the default layout it displays as:

Name - Month - Cases
User1 Jan 100
User1 Feb 47
User2 86 67

Any advice much appreciated..

regards

this would require hand coding to achieve and is not supported.


you would need to set the recordset to order by the month

Then in the repeat region add code to set a variable that contains the current month and create the first header.

on writing the next record, compare the month stored in the variable to see if they are the same or different. if different, crete a new heading and reset the variable value.

Thanks Jason, as I thought way above my expertise, but I may have a crack anyway.

Cheers