I am trying to build a table
to look like this
A B C
Date Total Date Total Date Total
2012-11-12
1
2012-11-13
5
2012-11-14
3
2012-11-14
1
2012-11-14
1
2012-11-15
3
2012-11-15
1
2012-11-17 2



What I get is
A B C
Date Total Date Total Date Total
2012-11-12 1
2012-11-13 5
2012-11-14 1
2012-11-14 3
2012-11-14 1
2012-11-15 1
2012-11-15 3


Here is the Code that I am useing
PHP Code:
<?php 
do 

    echo 
'<tr>';      
        if ( 
$row_getSchedule['Date_Start'] = $row_getSchedule['Date_Start'])
        {
            if (
$row_getSchedule['Event'] ==A)
            {
                echo 
'<td>';
                echo 
$row_getSchedule['Date_Start'];
                echo 
'</td>';
                echo 
'<td>';
                echo 
$row_getSchedule['evtNum'];
                echo 
'</td>';
            }
            else 
            {
                echo
'<td></td>';
                echo
'<td></td>';
            }

            if (
$row_getSchedule['Event'] == B)
            {
            echo 
'<td>';
            echo 
$row_getSchedule['Date_Start'];
            echo 
'</td>';
            echo 
'<td>';
            echo 
$row_getSchedule['evtNum'];
            echo 
'</td>';
            }
                        else 
            {
                echo
'<td></td>';
                echo
'<td></td>';
            }

            if (
$row_getSchedule['Event'] == C)
            {
            echo 
'<td>';
            echo 
$row_getSchedule['Date_Start'];
            echo 
'</td>';
            echo 
'<td>';
            echo 
$row_getSchedule['evtNum'];
            echo 
'</td>';
            }
            else 
            {
                echo
'<td></td>';
                echo
'<td></td>';
            }
                
        }
            
        
    echo 
'</tr>';

while (
$row_getSchedule mysql_fetch_assoc($getSchedule)); ?>