troubleshooting Question

Checkbox keeps showing up on filter

Avatar of David Schure
David Schure asked on
HTMLPHP
2 Comments1 Solution11 ViewsLast Modified:
The checkbox keeps showing up on filter and the format is all off on filter as well.
<label>Filter by therapist clients</label>
      <?php
$sql = <<< EOT
          SELECT tbl_client.client_id, tbl_client.client_name
        FROM tbl_client
        JOIN tbl_therapist_client
        ON tbl_therapist_client.client_id=tbl_client.client_id
         JOIN tbl_session
        ON tbl_session.client_id=tbl_client.client_id
         WHERE tbl_therapist_client.therapist_id = $therapist_id
           AND tbl_session.session_status = "Paid"
         GROUP BY tbl_client.client_id
        ORDER BY tbl_client.client_name ASC;
EOT;
        $results = $db->query($sql);
        echo "<select name='myClients'>";
      echo "<option value='0'>Show All</option>";
      while ($row = $results->fetch(PDO::FETCH_OBJ)) {
         printf("<option value='%s'>%s</option>", $row->client_id, $row->client_name);
      }
         echo "</select>";   
   ?>
From this
To this..
The link
https://arise.plus/THERAPIST/view-paid.php
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros