I didn't know if this should be in php or database section because it deals with both. Anyway, I have page 1 sending information from a form to page 2. This includes the variable $HomeAddress. On page 2 I have an sql query to get the value of Task1 which is stored in the database (a separate table from the one I am inserting into) and then insert Task1 and HomeAddress into the table.

The value of Task1 in the other table is something like: Hi, this is my address $HomeAddress if you want to drop by.

Now, I am trying to output Task1 on another page inside of a textarea. But I want it to show: Hi, this is my address 555 Some st. if you want to drop by.

But I am only getting this in the textarea: Hi, this is my address $HomeAddress if you want to drop by.

How do I insert that value into the textarea variable with php?

Just some notes on the code: It's Mysqli PDO. PHP 7. Here is the relevant code:

if ($_SERVER["REQUEST_METHOD"] == "POST") {
 // collect value of input field
 $id = $_POST['id'];
 $HomeAddress = $_POST['HomeAddress'];
 $ListName= $_POST['ListName'];
}
$sql = "SELECT Task1 FROM AutoPilotTaskLists WHERE ListName = '$ListName'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
 // output data of each row
 while($row = $result->fetch_assoc()) {
 $Task1 = $row["Task1"];
  }
} else {
 echo "0 results";
}
 if (!empty($Task1)) {
$sql = "INSERT INTO Tasks (HomeAddress, Task1) VALUES ('$HomeAddress', (SELECT Task1 FROM AutoPilotTaskLists WHERE ListName = '$ListName'))";
$result = $conn->query($sql);
} 

The following is what I have for the textarea:

<textarea name=\"Task1\" id=\"Task1\" rows=\"5\" cols=\"45\" value=\"" . $row["Task1"]. "\">" . $row["Task1"]. "</textarea>