|
|
Posted by toodi4 on 12/07/06 00:38
I'm trying to arrange some data output that will go into a series of
identical tables:
The data needs to be arranged as such:
Company 1 item 1 subitem 1
subitem 2
item 2 subitem A
subitem B
all data comes from a single table, and the above all represent
individual rows. So in the db, Company 1 would be in all rows, item 1
would be in the rows of the two subitems, etc. I'm assuming I could
get those fields to not repeat by using 'Distinct.'
What I'm having a problem with is that the above would be within 1
table, with its own set of column labels and bordering. And then
additional identical tables would follow for Company 2, Company 3, etc.
(actually, it is a little more complicated because each Company table
has to be sub-divided with different categories of items. But I
suspect the solution will be within the same concept)
How do I get php to create a separate table for each Company? I am
very used to using 'while' loops to populate tables. But usually when
I do this I just create separate tables for separate queries. I'm not
certain of the way to do the loop so for every Company a separate table
starts.
I don't need the full coding, I just need to be pointed in the right
direction.
Thanks!
Navigation:
[Reply to this message]
|