I am trying to build a table
to look like this
| A |
|
B |
|
C |
|
| Date |
Total |
Date |
Total |
Date |
Total |
|
|
|
|
|
1 |
|
5 |
|
|
|
|
|
3 |
|
1 |
|
1 |
|
3 |
|
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)); ?>
Bookmarks