I have a query that is returning the correct number of rows. However, when I try to print the rows out, it will not print the first row, but all after that. I can't figure out why it isn't printing out the first row, even though the query is returning the results. Here is my code below to print the results in a table: Any suggestions?
while($row2 = mysql_fetch_array($result1))
{
$affinity_name = $row2['affinity_name'];
$affinity_detail = $row2['affinity_detail'];
$affinity_no = $row2['affinity_name'];
$track_id = $row2['id'];
get_name($affinity_name);
$affinity_details .=<<<EOD
<tr>
<td><a href="/m_t5.php?affinity_id=$affinity_no&q=$name">$name</a></td>
<td>$affinity_detail</td>
<td><a href="/delete_track.php?track_id=$track_id">Delete</a></td>
</tr>
EOD;
}