//
// Print rows from query - PerformanceDBA - 25 May 15
//
// PHP/MyNONsql Code
// for Captain Crunch
// at http://stackoverflow.com/questions/30249131/
//

// init print formats.  Debug only (includes id), not for users
$hdr_person = "person_id full_name                      phone_number\n";
$lin_person = "--------- ------------------------------ ------------\n";
$fmt_person = "%9s %-30s %-12s\n";
print $hdr_person;
print $lin_person;

//---------------------------------------
// get all persons and phoneNumbers, once
$sql = "
    SELECT  persons.id,
            fullName,
            phoneNumber
        FROM persons
        LEFT JOIN phoneNumber
            ON persons.id = phoneNumber.personId";
$result = mysql_query( $sql );

//---------------------
// while result-set row
while ( $row = mysql_fetch_assoc( $result ) ) {
	printf ( $fmt_person, $row[ 'id' ], $row[ 'fullName' ], $row[ 'phoneNumber' ] );
    }

//----------------
// pretty printing
while ( $row = mysql_fetch_assoc( $result ) ) {
    if ( $row[ 'id' ] != $prev_person_id ) {
        // new person
        printf ( $fmt_person, $row[ 'id' ], $row[ 'fullName' ], $row[ 'phoneNumber' ] );
        $prev_person_id = $person[ 'id' ];
        }
    else
        // same as previous person
        printf ( $fmt_person, "", "", $row[ 'phoneNumber' ] );
    }