I have a report generator (built with DW) that allows you to enter Action Items and Bullet Statements (two separate forms). It worked fine before and then I found there were some errors now that I want to actually use it. Anyway, on the display page, it lists the Action Items and Bullet Statements in separate tables.
<?php do { ?>
[INDENT]<tr>
[INDENT]<?php if (!empty($row_ai['ai_number'])) { echo '<td width="10%" valign="top" class="CELLtext2"><input type="hidden" name="id" value=',$row_ai['id'],'>',$row_ai['ai_number'],'</td>
<td valign="top" class="CELLtext2">',$row_ai['ai_issue'],'</td>';
if ($row_ai['new'] == '1')
{
echo '<td width="80%" valign="top" bgcolor="FFFF00" class="CELLtext2">',$row_ai['ai_status'],'</td>';
}
else
{
echo '<td width="80%" valign="top" class="CELLtext2">',$row_ai['ai_status'],'</td>';
}
;} else {echo '<td colspan="3" class="CELLtext2">There has been no data submitted for this section.</td>';} ?>[/INDENT]
</tr>[/INDENT]<?php } while ($row_ai = mysql_fetch_assoc($ai)); ?>
<?php do { ?>
[INDENT]<tr>
[INDENT]<?php if (!empty($row_bullets['bullet_section'])) { echo '<td width="20%" valign="top" class="CELLtext2"><input type="hidden" name="id" value=',$row_bullets['id'],'>',$row_bullets['bullet_section'],'</td>';
if ($row_bullets['bullet_new'] == '1')
{
echo '<td width="80%" valign="top" bgcolor="FFFF00" class="CELLtext2">',$row_bullets['bullet'],'</td>';
}
else
{
echo '<td width="80%" valign="top" class="CELLtext2">',$row_bullets['bullet'],'</td>';
}
;} else {echo '<td colspan="2" class="CELLtext2">There has been no data submitted for this section.</td>';} ?>[/INDENT]
</tr>[/INDENT]<?php } while ($row_bullets = mysql_fetch_assoc($bullets)); ?>
If I clear the DB and add a Bullet Statement, it displays "There has been no data submitted for this section." on the first row and then the Bullet Statement information I just entered. If I add an Action Item, it adds the Action Item correctly and does not display "There has been no data submitted for this section." anymore (working as it should). I have checked the insert pages and there are no references to Bullet Statement in the Action Items insert page or vice versa. If I make it (empty vs (!empty for the Bullet Statement display, it displays "There has been no data submitted for this section." as many times as there are Action Items. What the heck could it be referencing on Action Items?
Action Items table elements are:
id
new
ai_number
ai_issue
ai_status
Bullet Statement table elements are:
id
bullet_new
bullet_section
bullet
When I check the DB, Action Item elements are only populated with Action Item information and the same goes for the Bullet Statements.
Signed,
Banging Head Against Wall, III
