根据点击的复选框/单选按钮，使用mysql从8列中抽取1列

我即将让这个网站正常运行。在这个网站上伟大的人的帮助下，我找到了我最后一个问题的解决方案，我还有一个问题。我的网站上有8个input字段，这些字段将根据选择的专业知识提取代理信息。如果数据库的设置不同，但我无法更改数据库的结构，那么这很可能会容易得多。

网站的实时版本

我的数据库结构：

ID | MemberID | First_Name | Last_Name | Ancillary | LongTerm | Medicare |  ETC..<br />
 1 | 77777    | John       | Doe       | 1         | 1        | 0        | ETC..

现在，我需要根据用户选择的专业知识提取信息。由于我的专业领域各有一列，它们的值为1表示是，0表示否，这对于新手程序员来说一定会更复杂一些。

用于根据选择的值进行拉取的HTML：

<label for="agent">Agent Expertise</label><br />
<label for="ancillary"><input type="radio" value="Ancillary" onChange="showUser(this.value)" name="expertise[]" id="ancillary" />Ancillary</label><br />
<label for="smallgroup"><input type="radio" value="Smallgroup" onChange="showUser(this.value)" name="expertise[]" id="smallgroup" />Small Group</label><br />
<label for="largegroup"><input type="radio" value="LargeGroup" onChange="showUser(this.value)" name="expertise[]" id="largegroup" />Large Group</label><br />
<label for="medicare"><input type="radio" value="Medicare" onChange="showUser(this.value)" name="expertise[]" id="medicare" />Medicare</label><br />
<label for="longterm"><input type="radio" value="LongTerm" onChange="showUser(this.value)" name="expertise[]" id="longterm" />Long Term Care</label><br />
<label for="individual"><input type="radio" value="Individual" onChange="showUser(this.value)" name="expertise[]" id="individual" />Individual Plan</label><br />
<label for="tpa"><input type="radio" value="TPASelfInsured" onChange="showUser(this.value)" name="expertise[]" id="tpa" />TPA Self Insured</label><br />
<label for="ppaca"><input type="radio" value="CertifiedForPPACA" onChange="showUser(this.value)" name="expertise[]" id="ppaca" />Certified for PPACA</label><br />

jQuery我曾经使用ajax将信息拉入并发布到div中：

更新了我的jQuery和AJAX

$(document).ready(function() {
        $('input').on('click', function() {
            var value = $(this).val();
            $.ajax({
                type: 'POST',
                data: ({expertise: value}),
                url: "expertise.php",
                success: function (data) {
                    $('#bodyA').html(data);
                }
            });
        });
    })

现在sql是我遇到麻烦的地方：

$sql="SELECT * FROM `roster` WHERE Ancillary = '1' OR SmallGroup = '1' OR IndividualPlans = '1' OR LongTermCare = '1' OR Medicare = '1' OR LargeGroup = '1' OR TPASelfInsured = '1' OR CertifiedForPPACA = '1' ORDER BY Last_Name ASC";

当我使用OR时，它会调用数据库中的每个人，但当我使用AND时，它只调用具有各种专业知识的代理。（对我来说很有意义）
PHP文件：

include 'datalogin.php'; // PHP File to login credentials
        $sql="SELECT * FROM `roster` WHERE Ancillary = '1' OR SmallGroup = '1' OR IndividualPlans = '1' OR LongTermCare = '1' OR Medicare = '1' OR LargeGroup = '1' OR TPASelfInsured = '1' OR CertifiedForPPACA = '1' ORDER BY Last_Name ASC";
        $result = mysqli_query($con,$sql) // Connects to database
            or die("Error: ".mysqli_error($con));
            echo "<h1>" . "Find a Local OAHU Agent." . "</h1>";
            while ($row = mysqli_fetch_array($result)) { // Gets results from the database
                echo "<div class='agentcon'>" . "<span class='agentn'>" . "<strong>".$row['First_Name'] . "&nbsp;" .$row['Last_Name'] . "</strong>" . "</span>" . "<a href=mailto:".$row['Email'] . ">" . "<span class='email'>" . "Send an e-mail to" . "&nbsp;" .$row['First_Name'] . "</span>" . "</a>" ."<div class='floathr'></div>";
                if ($row['Company'] == NULL) {
                    echo "<p>";
                }
                else {
                    echo "<p>" . "<strong>" .$row['Company'] . "</strong>" . "<br>";
                }
                echo $row['WorkAddress1'] . "&nbsp;" .$row['WorkCity'] . "," . "&nbsp;" .$row['WorkStateProvince'] . "&nbsp;" .$row['WorkZipCode'] . "<br>";
                if ($row['Work_Phone'] !== NULL) {
                    echo "<strong>" . "Work" . "&nbsp;" . "</strong>" .$row['Work_Phone'] . "<br>";
                }
                if ($row['Fax'] !== NULL) {
                    echo "<strong>" . "Fax" . "&nbsp;" . "</strong>" .$row['Fax'] . "<br>";
                }
                echo "<strong>" . "Agent Expertise:" . "</strong>";
                if ($row['Ancillary'] == 1) {
                    echo "&nbsp;" . "Ancillary" . "/";
                }
                if ($row['SmallGroup'] == 1) {
                    echo "&nbsp;" . "Small Group" . "/";
                }
                if ($row['IndividualPlans'] == 1) {
                    echo "&nbsp;" . "Individual Plans" . "/";
                }
                if ($row['LongTermCare'] == 1) {
                    echo "&nbsp;" . "Long Term Care" . "/";
                }
                if ($row['Medicare'] == 1) {
                    echo "&nbsp;" . "Medicare" . "/";
                }
                if ($row['LargeGroup'] == 1) {
                    echo "&nbsp;" . "LargeGroup" . "/";
                }
                if ($row['TPASelfInsured'] == 1) {
                    echo "&nbsp;" . "TPA Self Insured" . "/";
                }
                if ($row['CertifiedForPPACA'] == 1) {
                    echo "&nbsp;" . "Certified For PPACA";
                }
                echo "</p>" . "</div>";
            }
        mysqli_close($con);