Query Print Help

[Anon]

Everyone thanks for all the help here on the forum.
I was helped with this bit of code earlier but I have some changes made and need some assistance with it.

$sql = "SELECT hdr_id, hdr_text, grp_name FROM header, groups WHERE job_number='$job_number' AND header.grp_id = groups.grp_id";
$result = db_query($sql);
$numrows = mysql_num_rows($result);

$sql = "SELECT hdr_id, hdr_text, grp_name FROM header, groups WHERE job_number='$job_number' AND header.grp_id = groups.grp_id";
$result = db_query($sql);
$numrows = mysql_num_rows($result);

for($i = 0; $i < $numrows; $i++) {

print mysql_result($result, $i, "grp_name")."<br>\n";
print mysql_result($result, $i, "hdr_text")."<br>\n";

// Get the header id
$cur_headerid = mysql_result($result, $i, "hdr_id");

// Grab the files with this id
$sql2 = "SELECT * FROM files WHERE hdr_id='$cur_headerid'";
$result2 = db_query($sql2);
$numrows2 = mysql_num_rows($result2);

for($j = 0; $j < $numrows2; $j++) {
// Print the subheading with indenting
$cur_subtext = mysql_result($result2, $j, "file_text");
print " - $cur_subtext<br>\n";
}
}

This code works great it prints the following:

Group1
Header 1
--Sub Head 1
--Sub Head 2
--Sub Head 3
Group 1
Header 2
--Sub Head 1
--Sub Head 2
--Sub Head 3
Group 2
Header 1
ect...

My question is how do I get rid of that second print of Group 1? I don't want to have that print twice. So it would print like this:

Group1
Header 1
--Sub Head 1
--Sub Head 2
--Sub Head 3
Header 2 (Notice the print of Group 1 is gone)
--Sub Head 1
--Sub Head 2
--Sub Head 3
Group 2
Header 1
ect...

Thanks,
Troy