I've got a bit of a mess lol. My goal is to have 3 pages. One for tasks over due, one for current due tasks, and one for future due tasks. What I have done is created a database with columns for each task (up to 15) and named them Task1, Task2, and so on. These columns hold the instructions for the user to complete their task for the day. I have another column called TaskDueDate to hold the due dates. When a new task is added a new row is created for each task (row 1 has the Task1 column filled in and the TaskDueDate filled in, then row 2 has the Task2 column filled in and the TaskDueDate filled in and so on).

Now, here's what I have done. On the Future Due Tasks page I have created multiple sql queries. One query for each task due. In the query I limit it to only tasks that are not null, only tasks in certain lists (which is another column in the table), and only tasks that are due on future dates.

This works to get the future tasks. BUT I am not able to order the results properly. I end up with the first few rows being all task 1 items even though some task 2's have earlier dates they are further down in the list. I'll show you the code so you can see what I mean:

$sql = "SELECT UserID, FirstName, LastName, Phone, HomeAddress, ListName, Task1, TaskDueDate FROM Tasks WHERE ListName = 'FSBO' AND TaskDueDate > '$TaskDueDate' AND Task1 IS NOT NULL OR ListName = 'Expired' AND TaskDueDate > '$TaskDueDate' AND Task1 IS NOT NULL OR ListName = 'FSBO In Escrow' AND TaskDueDate > '$TaskDueDate' AND Task1 IS NOT NULL OR ListName = 'FSBO Fell Out Of Escrow' AND TaskDueDate > '$TaskDueDate' AND Task1 IS NOT NULL";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
 // output data of each row
 while($row = $result->fetch_assoc()) {
echo "<div class=\"OuterDatabaseRowType2\">
<div class=\"InnerDatabaseRowType2ProfilID\"><ul class=\"second\"><li class=\"second\"><a href=\"../CompleteFutureTask.php/?UserID=" . $row["UserID"] . "&TaskDueDate=" . $row["TaskDueDate"] . "&ListName=" . $row["ListName"]. "&Phone=" . $row["Phone"] . "\">Complete Task</a></li></ul></div>
<div class=\"InnerDatabaseRowType2Name\">" . $row["FirstName"]. " " . $row["LastName"]. "</div>
<div class=\"InnerDatabaseRowType2Phone\">" . $row["Phone"]. "</div>
<div class=\"InnerDatabaseRowType2HomeAddress\"><textarea name=\"Task1\" id=\"Task1\" rows=\"5\" cols=\"45\">";?><?php echo str_replace(array('#HomeAddress#', '#FirstName#', '#LastName#'), array($row["HomeAddress"], $row["FirstName"], $row["LastName"]), $row["Task1"]);?><?php echo "</textarea> </div>
<div class=\"InnerDatabaseRowType2CreationDate\">" . $row["ListName"]. "</div>
          <div class=\"InnerDatabaseRowType2Green\"></div>
</div>";
 }
}

$sql = "SELECT UserID, FirstName, LastName, Phone, HomeAddress, ListName, Task2, TaskDueDate FROM Tasks WHERE ListName = 'FSBO' AND TaskDueDate > '$TaskDueDate' AND Task2 IS NOT NULL OR ListName = 'Expired' AND TaskDueDate > '$TaskDueDate' AND Task2 IS NOT NULL OR ListName = 'FSBO In Escrow' AND TaskDueDate > '$TaskDueDate' AND Task2 IS NOT NULL OR ListName = 'FSBO Fell Out Of Escrow' AND TaskDueDate > '$TaskDueDate' AND Task2 IS NOT NULL";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
 // output data of each row
 while($row = $result->fetch_assoc()) {
echo "<div class=\"OuterDatabaseRowType2\">
<div class=\"InnerDatabaseRowType2ProfilID\"><ul class=\"second\"><li class=\"second\"><a href=\"../CompleteFutureTask.php/?UserID=" . $row["UserID"] . "&TaskDueDate=" . $row["TaskDueDate"] . "&ListName=" . $row["ListName"]. "&Phone=" . $row["Phone"] . "\">Complete Task</a></li></ul></div>
<div class=\"InnerDatabaseRowType2Name\">" . $row["FirstName"]. " " . $row["LastName"]. "</div>
<div class=\"InnerDatabaseRowType2Phone\">" . $row["Phone"]. "</div>
<div class=\"InnerDatabaseRowType2HomeAddress\"><textarea name=\"Task2\" id=\"Task2\" rows=\"5\" cols=\"45\">";?><?php echo str_replace(array('#HomeAddress#', '#FirstName#', '#LastName#'), array($row["HomeAddress"], $row["FirstName"], $row["LastName"]), $row["Task2"]);?><?php echo "</textarea> </div>
<div class=\"InnerDatabaseRowType2CreationDate\">" . $row["ListName"]. "</div>
          <div class=\"InnerDatabaseRowType2Green\"></div>
</div>";
 }
}

As you can see the code is far too messy. I feel that there must be a way to sort it out better than this. I could use some help figuring out how to clean it up so that I can use only 1 sql query if possible to get each task due in the future and order them all by date without having to display the results in batches of task1's and then task2's and so on.