How to put the SQL column data into PHP variable?

See more:

PHP

MySQL

Let's say I have an "append" table and a "weight" column in the database.

I want the "weight" value put into a PHP variable.

How can I handle that?

What I have tried:

<pre lang="PHP">
    $sql = "SELECT weight FROM append";

    if ($conn->query($sql) === TRUE) {
        echo "Successful";
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }

    echo $sql;