mardi 8 janvier 2019

IF ELSE statement with multiple line in MySQL-DB

first I'm my English, but I will try.

In my SQL-DB I have some rows, there are changing results every week. Example:

example

Now my question: how do I make a "IF ELSE" statement that shows up- or downgoing problems?

    $conn = OpenCon(); // kalder functionen, og ligger resultatet over i $conn

$sql = "SELECT problems FROM week WHERE id=1";
$s01 = $conn->query($sql);
$sql = "SELECT problems FROM week WHERE id=2";
$s02 = $conn->query($sql);
$sql = "SELECT problems FROM week WHERE id=3";
$s03 = $conn->query($sql);
$sql = "SELECT problems FROM week WHERE id=4";
$s04 = $conn->query($sql);
$sql = "SELECT problems FROM week WHERE id=5";
$s05= $conn->query($sql);
$sql = "SELECT problems FROM week WHERE id=6";
$s06 = $conn->query($sql);


//I guess my problem is under here 

if ($s01<$s02) {
        echo "ID 1 is highest";
} else {
    echo "ID 2 is higher than ID 2 or the same";
}

 $conn->close();

Like it is now my site only will show the following

ID 2 is higher than ID 2 or the same

Aucun commentaire:

Enregistrer un commentaire