How can I arrange data like this?

[scuzzo84]

Here is my php, in it I included at the top how my db is setup. My site is about looking up a skateboarder's name and seeing his/her sponsor. The problem is that when I click a persons name it comes up like this:

TONY HAWK
Adio 1998
birdhouse 1992
Airwalk 1991
Powell 1990

Instead I want it like this

TONY HAWK

DECKS
Powell 1990
Birdhouse 1993

SHOES
Airwalk 1991
Adio 1997

CLOTHING
etc etc....

=================================

<?php 
<?php 
/*

////MYSQL STRUCTURE////

CREATE TABLE skater (id INT AUTO_INCREMENT PRIMARY KEY, fname char(15), lname char(15));
CREATE UNIQUE INDEX skindex ON skater (fname, lname);

CREATE TABLE product (id INT AUTO_INCREMENT PRIMARY KEY, type char(15), name char(15));
CREATE UNIQUE INDEX prindex ON product (type, name);

CREATE TABLE sponsor (id INT AUTO_INCREMENT PRIMARY KEY, sid INT, pid INT, year INT);
CREATE UNIQUE INDEX spindex ON sponsor (sid, pid, year);

////SIMPLE VIEW////

skater [id, fname, lname]
product [id, type, name]
sponsor [id, sid, pid, year]

skater  [1, tony, hawk]
product [2, shoes, adio]
sponsor [1, 1, 2, 1997]

skater [2, tony, tave]
product [3, deck, element]
sponsor [1, 2, 3, 2005]

*/

include 'connect.php';

// Array for A-Z menu selection
echo "<h2>First Name</h2>";
$letters = array(A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z);
foreach ($letters as $value) {
	echo "<a href=index.php?letter=$value>$value</a> ";
}

// Print out names where the FIRST name starts with $value
echo "<br><br>";
if (isset($_GET['letter'])){
	$letter = $_GET['letter'];
	$query = "SELECT * FROM skater WHERE fname like '$letter%'";
	$result = mysql_query($query);
	$rows = mysql_num_rows($result);
	if ($rows < 1){
	echo "NO RESULTS";
	}else{
		while ($row = mysql_fetch_assoc($result)) {
			$id = $row['id'];
			$fname = $row['fname'];
			$lname = $row['lname'];
			echo "<a href=\"index.php?id=$id\">$fname $lname</a><br>";
		}
	}
}

// Board sponsor
if (isset($_GET['id'])){
	$id = $_GET['id'];
	$query = "SELECT * FROM sponsor 
	INNER JOIN skater ON sponsor.sid = skater.id 
	INNER JOIN product ON sponsor.pid = product.id 
	WHERE sid = $id";
	echo "$query<br><br>";
	$result = mysql_query($query);
	while ($row = mysql_fetch_assoc($result)){
		$fname = $row['fname'];
		$lname = $row['lname'];
		$type = $row['type'];
		$company = $row['name'];
		$year = $row['year']; 

	echo "$company $year<br>";
}
}

?>

[pete_bisby]

You need to place the query for retrieving the sponsor information within the while loop that retrieves the skater information. This will keep all of the relevant skater and sponsor information together.

[scuzzo84]

$query = "SELECT * FROM sponsor
INNER JOIN skater ON sponsor.sid = skater.id
INNER JOIN product ON sponsor.pid = product.id
WHERE sid = $id";

place that in the last while loop? I really dont get this

[pete_bisby]

// Print out names where the FIRST name starts with $value 
echo "<br><br>"; 
if (isset($_GET['letter'])){ 
    $letter = $_GET['letter']; 
    $query = "SELECT * FROM skater WHERE fname like '$letter%'"; 
    $result = mysql_query($query); 
    $rows = mysql_num_rows($result); 
    if ($rows < 1){ 
    echo "NO RESULTS"; 
    }else{ 
        while ($row = mysql_fetch_assoc($result)) { 
            $id = $row['id']; 
            $fname = $row['fname']; 
            $lname = $row['lname']; 
            echo "<a href=\"index.php?id=$id\">$fname $lname</a><br>";

        $query2 = "SELECT * FROM sponsor 
        INNER JOIN skater ON sponsor.sid = skater.id 
        INNER JOIN product ON sponsor.pid = product.id 
        WHERE sid = $id"; 
        echo "$query2<br><br>"; 
        $result2 = mysql_query($query2); 
        while ($row2 = mysql_fetch_assoc($result2)){ 
          $fname2 = $row2['fname']; 
          $lname2 = $row2['lname']; 
          $type2 = $row2['type']; 
          $company2 = $row2['name']; 
          $year2 = $row2['year']; 

          echo "$company2 $year2<br>"; 
        } 
    } 
} 
} 

I didn't say place the code in the last while loop, I said place the code for the sponsor information within the loop for the skater information, which is exactly what is displayed above.