Both of these are using the same DB connection($conn) and both currency and level are in the table, yet when I run my page, it shows currency, but level comes up blank.
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
} else{
echo 'Connected! ';
$sql = "SELECT * FROM KJE WHERE username = '$user' AND password = '$pass' ";
$result = mysqli_query($conn,$sql);
$check = mysqli_fetch_array($result);
if(isset($check)){
$_SESSION['username'] = $user;
//BELOW WAS WORKING. WHILE TROUBLESHOOTING I CHANGED IT. WHEN I CTRL+Z BACK TO IT'S ORIGINAL IT STOPPED WORKING. I GUESS I'M DOING SOMETHING FUNDAMENTALLY WRONG AND GOT LUCKY?
//------currency------
$sql2 = ("SELECT currency FROM KJE WHERE username = '{$_SESSION['username']}' ");
$result2 = mysqli_query($conn,$sql2);
$currency = mysqli_fetch_array($result2);
for($a = 0 ; $a < count($_SESSION['currency']) ; $a++){
$_SESSION['currency'] = $currency[$a];
}
//BELOW DOES NOT WORK
//------level------
$sql3 = ("SELECT `level` FROM KJE WHERE username = '{$_SESSION['username']}' ");
$result2 = mysqli_query($conn,$sql3);
$level = mysqli_fetch_array($result2);
for($b = 0 ; $b < count($_SESSION['level']) ; $b++){
$_SESSION['level'] = $level[$b];
}
}