Avatar of David Schure
David Schure

asked on 

Checkbox keeps showing up on filter

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>";   
   ?>

Open in new window

From this
User generated imageTo this..
User generated imageThe link
https://arise.plus/THERAPIST/view-paid.php
HTMLPHP

Avatar of undefined
Last Comment
David Schure
ASKER CERTIFIED SOLUTION
Avatar of David H.H.Lee
David H.H.Lee
Flag of Malaysia image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of David Schure
David Schure

ASKER

Hi David. I found the problem....it was deep in the structure.  Thank you for your help.  See my other question Query Sort.
PHP
PHP

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

125K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo