[RESOLVED] How to display without multiples

[MystedVeil]

table1: member
member_id
member_name
member_account
etc..

table2: member_locations
mloc_id
member_id
location

as it stands info is returning:

member name 1 - member account 1 - location 1
member name 1 - member account 1 - location 2

how I would like for it to return is:
member name 1 - member account 1 - location 1, location 2 , etc for however many locations are related to member account.

A point in the right direction would be greatly appreciated, not quite sure what to search for on that either.

[tjohnson_nb]

How about

$result=mysql_query("SELECT member_id, member_name, member_account FROM member");
while ($row=mysql_fetch_row($result)) {

}

[tjohnson_nb]

How about

$result=mysql_query("SELECT member_id, member_name, member_account FROM member");
while ($row=mysql_fetch_row($result)) {
       $member_id=$row[0];
       $member_name=$row[1];
       $member_account=$row[2];
       $result1=mysql_query("SELECT location FROM member_locations WHERE member_id=$member_id");
       while ($row1=mysql_fetch_row($result1)) {
               $location=$row1[0];
// Not sure how you want to format your info but can start here.                

       }
}