Grouping query results and putting in a table

Codes here !

Moderators: egami, macek, gesf

Post Reply
fredws
New php-forum User
New php-forum User
Posts: 14
Joined: Wed Jul 16, 2003 4:16 pm

Wed Jul 16, 2003 5:14 pm

I hope I am in the right forum to ask this.
I have a database with a company table and a clients table. There are several clients for each company. What I am wanting to do is group these, such as putting them in a table or box where I would have :
Company1
client1 info
client2 info
client3 info

Company2
client1 info
client2 info

and so on.

Right now, I can get it to print them all out, but they are not grouped.
TIA!

User avatar
Redcircle
Moderator
Moderator
Posts: 826
Joined: Tue Jan 21, 2003 10:42 pm
Location: Michigan USA
Contact: