Q:

How to save 2 data from SQL into 2 different PHP variables?

I'm fetching data from 2 tables with one common column and and the query is returning values as expected. How to save these two values "Normal" and "Normal" gotten from "disease" and "cases" column, into 2 different variables in PHP?
This is my query:
SELECT healthdb.disease, criminaldb.cases 
FROM criminaldb NATURAL JOIN healthdb WHERE aadharnos = {$aadharnos};

The output was:

How to save this text "Normal" in PHP variable {$case} and other value, "Normal" in another PHP variable {$disea} so that I can compare them within if condition for my next part of my code

A:

You can use fetch-assoc so you will have all the data return from the SQL query in PHP variable. 
Consider the following:
$query = "SELECT healthdb.disease, criminaldb.cases FROM criminaldb NATURAL JOIN healthdb WHERE aadharnos = $aadharnos;";
$results = $connectToDb->query($query);
while($row = $results->fetch_assoc()){
    print_r($row);
    //here you can access the row data returned and save your data in local variable 
    $crim = $row["cases"]; 
    $dis = $row["disease"]; 
    if($crim == "Normal" AND $dis == "Normal) {
    // or you can just do: if($row["cases"] == "Normal" AND $row["disease"] == "Normal) {
        //some code
    }

}

