Help printing query results

[Anon]

Hello,

I am having problems printing the results from a SQL query. I am trying to get the header sub_header values pairs to print as follows:

Header 1
- Sub Head 1
- Sub Head 2
- Sub Head 3

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

$sql = \"SELECT hdr_text, file_text FROM header, files WHERE header.hdr_id = files.hdr_id AND job_number=\'$job_number\'\";

$result=sql_query($sql);
So this is what I have returned:
Header 1 Sub Head 1
Header 1 Sub Head 2
Header 1 Sub Head 3
Header 2 Sub Head 1
Header 2 Sub Head 2
Header 2 Sub Head 3
ect..

This is where I am stumped. How do I write the rest to go through the array and print the Main Header and associated Sub Heads below?

Thanks,
Troy

[Anon]

Hi,

Why don't you try seperating the process into 2 queries. The first could look for all the headings, and then for each heading a new query is run to get the subheadings for that heading.

$sql = "SELECT * FROM header WHERE job_number=$job_number";
$result = mysql_query($sql);
$numrows = mysql_num_rows($result);

for($i = 0; $i < $numrows; $i++) {
// Print this header (you could always add it to an array here, or anything else for that matter)
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
$sql = "SELECT * FROM files WHERE hdr_id=$cur_headerid AND job_number=$job_number";
$result2 = mysql_query($sql);
$numrows2 = mysql_num_rows($result2);

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

Hope that makes sense, it's not incredibly elegent, but it'll work and the logic's quite nice (it won't fall on it's arse if theres no subheadings for a heading, for example).

Dom
🙂

[Anon]

Thanks for the help Dom that worked out great! Makes perfect sense to me.

Thanks,
Troy

[Anon]

Dom:

Here is one more little twist to the logic.
Lets say in the header table I have a grp_id field that stores what group the header belongs to. So now instead of just printing the headers and associated subheads the headers are also placed in a group. So it looks like the following:

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

The first query would have the grp_id field returned with it. Would I have to separate this process also to collect the groups?

Thanks,
Troy