first I'm my English, but I will try.
In my SQL-DB I have some rows, there are changing results every week. 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