Session werkt niet goed met mysql records door loop probleem

Mijn php pagina hier beneden (example.php) werkt verder goed en de resultaten van de dbase query worden goed weergegeven (alle records). Maar als ik naar een volgende pagina ga (output.php) en daar de session gegevens weer oproep laat hij enkel de laatste record zien. Ik begrijp dat dit komt doordat session in de while loop staat in emample.php. Maar ik weet niet hoe ik het dan moet wijzigen. Kan iemand mijn scrip aanpassen. Het is vast heel eenvoudig?

De example.php file:

<?php
//session starts
session_start();

// Database selection and pH selection (this comes from a form+post file where the pH level is asked for and selected)
switch ($_POST["pH"]) {

//Option 1 (I put xxxx for privacy purposes, guess you understand) (c1, c2, c3 are the selections you could make in the Form)
case "c1":
$con = mysqli_connect("localhost", "xxxx", "") or die (mysql_error ());
if (!$con) {die('Could not connect: ' . mysqli_error($con));}
mysqli_select_db($con,"xxx")or die(mysql_error());

//change query here
$sql="SELECT * FROM people WHERE rain <=200 AND Soil IN ('Sand','Sand Clay', 'Sand Clay Silt') AND pH<=4.5";
$result = mysqli_query($con,$sql);
break;

//Option 2
case "c2":
$con = mysqli_connect("localhost", "xxxx", "") or die (mysql_error ());
if (!$con) {die('Could not connect: ' . mysqli_error($con));}
mysqli_select_db($con,"xxx")or die(mysql_error());

//change query here
$sql="SELECT * FROM people WHERE rain <=200 AND Soil IN ('Sand','Sand Clay', 'Sand Clay Silt') AND pH BETWEEN 4.5 AND 7.0";
$result = mysqli_query($con,$sql);
break;

//Option 3
case "c3":
$con = mysqli_connect("localhost", "xxxx", "") or die (mysql_error ());
if (!$con) {die('Could not connect: ' . mysqli_error($con));}
mysqli_select_db($con,"xxx")or die(mysql_error());

//change query here
$sql="SELECT * FROM people WHERE rain <=200 AND Soil IN ('Sand','Sand Clay', 'Sand Clay Silt') AND pH >=7.0";
$result = mysqli_query($con,$sql);
break;


//default when nothing is selected
default:
$strpH = "Please go back and make your selection";
break;
}





//here starts the echo part for this page.


// printing main table
echo "<table>
<tr bgcolor=#339966>
<th>id</th>
<th>Common Name</th>
<th>Latin Name</th>
<th>pH level</th>
<th>Soil</th>
<th>Rain annual</th>
</tr>";

// Loop the recordset $result and Write the value van $result

while($row = mysqli_fetch_array($result))
{
$queryArray[] = $row;

// Declaration of session items...here something has to be changed.
$_SESSION ['select1']= $row [id];
$_SESSION ['select2']= $row ['CommonName'];
$_SESSION ['select3']= $row ['LatinName'];
$_SESSION ['select4']= $row [pH];
$_SESSION ['select5']= $row ['Soil'];
$_SESSION ['select6']= $row [rain];

echo "<tr>";
echo "<td>" .$row[id]. "</td>";
echo "<td>" .$row['CommonName']. "</td>";
echo "<td>" .$row['LatinName']. "</td>";
echo "<td>" .$row[pH]. "</td>";
echo "<td>" .$row['Soil']. "</td>";
echo "<td>" .$row[rain]. "</td>";
echo "</tr>";
}
echo "</table>";

// Close the database connection
mysqli_close($con);
?>






En hieronder de output.php file

<?php
ini_set('display_errors', 'On');
error_reporting(E_ALL);

session_start();

// setting the table
echo "<table>
<tr bgcolor=#339966>
<th>id</th>
<th>Common Name</th>
<th>Latin Name</th>
<th>pH level</th>
<th>Soil</th>
<th>Rain annual</th>
</tr>";


//readig session variables
echo "<tr>";
echo "<td>" .$_SESSION ['select1']. "</td>";
echo "<td>" .$_SESSION ['select2']. "</td>";
echo "<td>" .$_SESSION ['select3']. "</td>";
echo "<td>" .$_SESSION ['select4']. "</td>";
echo "<td>" .$_SESSION ['select5']. "</td>";
echo "<td>" .$_SESSION ['select6']. "</td>";
echo "</tr>";
echo "</table>";
?>