Good morning all.
I am attempting to create a table in which there is a title cell populated
with a training wave number and then I would like to echo all members of
each training wave below the title cell (See example below for
clarification). All seems to be working with one exception. The first record
of each array is not being echoed. If I run the query in MySQL, all rows are
returned, so it must just be something I am not seeing in the code (which is
posted below). Thanks in advance for any help.
Randy
---------------------- START EXAMPLE ---------------------------
Training Wave: I-02
Brumley, Kennith
Dillard, Lori
Hamilton, Don
Larsen, Gerry
Robinson, Bobby
Sarabi, Ray
Shaddix, Kirby
Springer, Leon
Training Wave: II-02
Boles, Scooby
Deloney, Jerald
Russell, Roger
Smith, Martha
Stockman, Joe
Williams, Ed
ETC, ETC, ...
---------------------- END EXAMPLE ---------------------------
-------------------- BEGIN CODE SNIPET ---------------------------------
<?
$sql = "SELECT u.last_name, u.first_name, w.wave_id, w.wave_num
FROM USERS u, WAVES w
WHERE w.wave_id = u.wave_id
AND u.plant_id = '$plant_id'
ORDER BY w.wave_id ASC, u.last_name ASC";
$result = db_query ( $sql );
for ( $i = 0; $i < db_num_rows ( $result ); $i++ )
{
$record = db_fetch_object ( $result );
if ( $record->wave_num != "$prior_wave" )
{
$prior_wave = $record->wave_num;
?>
<table width="375" cellpadding="0" cellspacing="0"
border="0">
<tr>
<td colspan="2" height="10"><?php
echo FILLER; ?></td>
</tr>
<tr height=20 bgcolor="<? echo $color2; ?>">
<td><b
class="bGray"><b> Training Wave: <? echo $prior_wave; ?></b></td>
<td align="right"> </td>
</tr>
<tr>
<td colspan="2" height="10"><?php
echo FILLER; ?></td>
</tr>
</table>
<?
}
else
{
?>
<table width="575" cellpadding="0" cellspacing="0"
border="0">
<tr>
<td> <? echo
$record->last_name . ", " . $record->first_name; ?></td>
</tr>
</table>
<?
}
}
}
}
?>
------------------------- END CODE SNIPET
-------------------------------------------------
