gistfile1.aw

$players = array();

while($row = mysql_fetch_array($result))
{
    extract($row);
    $player = array (
        'cbs_id' => $cbs_id,
	'fname' => $fname,
	'lname' => $lname,
	'stats' => array()
    );

    $player['stats'][] = array(
        'year' => $year,
        'hr' => $hr,
        'rbi' => $rbi
    );
	
    $players[] = $player;
}   

$json = json_encode(array('players' => $players));
echo "<pre>$json</pre>";