PHP List

[arleslie]

I'm trying to make it display like this:

 

Group Name
member, member, member

Another Group
another member, another member, another member

 

Heres the table layout

 

Groups
   	id 	name 	captain 	luteinet 	major 	private

Members
   	id 	gamertag 	rank 	weapon 	bungie

 

I only want it to display the group name one and all of the members that link with that group.

I'm linking the two by "groups.name" and "members.rank"

[fenway]

The display has nothing to do with the query -- does the latter work?

[arleslie]

I don't under stand what you mean by latter

but what I need is just like a php layout that will make it the way I want.

So far I haven't had anyluck with the ways I've been trying.

[xtopolis]

fenway meant that how you display data doesn't have anything to do with how you query the database.

 

How does the Members table relate to the Group table?  Does each member have a Group ID = to one of the Groups.id ?  All we can see is that you have 2 tables, but no indicator that they are related..

 

if the Members table had a column like say: "gid" meaning group id, and each member had the value of an id in the Groups table, that would show their relation.

[arleslie]

I only want it to display the group name one and all of the members that link with that group.

I'm linking the two by "groups.name" and "members.rank"

As I stated above the to tables are linked by groups.name and members.rank.

members.rank has the same value as groups.name as of which group it's in.

[fenway]

So you're not joining the tables on a UID?  That's not going to be fun for performance.  Either way, it's a straight-forward join, and after that, the display is up to you.

[arleslie]

can a mod rename this to PHP List [MySQL] and move it to the PHP area?