Displaying MySQL data based on one column...

[tarbender]

I'm trying to format my table data to display character information based on the player name.

The table includes the following information:
id
character_name
breed
gender
base_color
markings
genetics
sire
dam
other
player
email

And I'd like it to display it in the following format:

Player 1
    character 1: name - breed - gender - base color - markings - genetics - sire - dam - other - id
    character 2: name - breed - gender - base color - markings - genetics - sire - dam - other - id

Player 2
     character 1: name - breed - gender - base color - markings - genetics - sire - dam - other - id
     character 2: name - breed - gender - base color - markings - genetics - sire - dam - other - id

I don't want the email to be displayed anywhere but the MySQL table due to privacy.  The trouble I'm having is that the player name is duplicated several times throughout the table due to the player having more than one character in play; so I'm trying to find a way to display the player name only once, but the rest of the information in that row below the player's name.  And then sorted alphabetically by the player name... I know how to display all of the information in a row once, as in it sorts by the character name... but for sanity's sake, I'd like it to display like the example above.

So basically I'd like it to display information based on the data in the "player" column of the table.

Make sense?  Is it possible to do with MySQL?

Forgive me for I'm not an expert in MySQL and PHP; I'm still learning.