PHP Mysql搜索页

Question

我有一个简单的搜索页面设置，它工作得很好，但是当我向mysql数据库添加一个列时，它不返回任何结果。去掉柱子，它又能工作了。我就是想不出我到底做错了什么。

这是我的searchresults.php，如果有用的话，我还可以截取我的数据库布局的屏幕截图。我已经为此苦苦挣扎了几个星期了，我需要把它收起来。

if(!$conn)
{
    die("Connection error: " . mysqli_connect_error());    
}
$searchterm = $_POST['searchterm'];
$qry = "select * from addresslighting WHERE name LIKE '%".$searchterm."%' UNION 
    select * from addresslighting WHERE catagory LIKE '%".$searchterm."%' UNION
    select * from arealighting WHERE name LIKE '%".$searchterm."%' UNION 
    select * from arealighting WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from bollards WHERE name LIKE '%".$searchterm."%' UNION 
    select * from bollards WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from canopyandgarage WHERE name LIKE '%".$searchterm."%' UNION 
    select * from canopyandgarage WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from canopyandgaragelinears WHERE name LIKE '%".$searchterm."%' UNION 
    select * from canopyandgaragelinears WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from ceilingflush WHERE name LIKE '%".$searchterm."%' UNION 
    select * from ceilingflush WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from commercialceiling WHERE name LIKE '%".$searchterm."%' UNION 
    select * from commercialceiling WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from commercialwall WHERE name LIKE '%".$searchterm."%' UNION 
    select * from commercialwall WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from customcreations WHERE name LIKE '%".$searchterm."%' UNION 
    select * from customcreations WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from directindirectlinears WHERE name LIKE '%".$searchterm."%' UNION 
    select * from directindirectlinears WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from floodlighting WHERE name LIKE '%".$searchterm."%' UNION 
    select * from floodlighting WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from linears WHERE name LIKE '%".$searchterm."%' UNION 
    select * from linears WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from pendantsandchandeliers WHERE name LIKE '%".$searchterm."%' UNION 
    select * from pendantsandchandeliers WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from polelight WHERE name LIKE '%".$searchterm."%' UNION 
    select * from polelight WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from poles WHERE name LIKE '%".$searchterm."%' UNION 
    select * from poles WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from hilowbaylinears WHERE name LIKE '%".$searchterm."%' UNION 
    select * from hilowbaylinears WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from posttopfixtures WHERE name LIKE '%".$searchterm."%' UNION 
    select * from posttopfixtures WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from retrofits WHERE name LIKE '%".$searchterm."%' UNION 
    select * from retrofits WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from undercabinetlinears WHERE name LIKE '%".$searchterm."%' UNION 
    select * from undercabinetlinears WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from vandalresistantlinears WHERE name LIKE '%".$searchterm."%' UNION 
    select * from vandalresistantlinears WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from vanity WHERE name LIKE '%".$searchterm."%' UNION 
    select * from vanity WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from wallpacks WHERE name LIKE '%".$searchterm."%' UNION 
    select * from wallpacks WHERE catagory LIKE '%".$searchterm."%' UNION 
    select * from wallsconce WHERE name LIKE '%".$searchterm."%' UNION 
    select * from wallsconce WHERE catagory LIKE '%".$searchterm."%'";
$rs = mysqli_query($conn,$qry);
$index = 0;
$position = "first";

// This while loop gets all the results and places each one in the $getRowAssoc variable (makes parsing easier)
while ($getRowAssoc = mysqli_fetch_assoc($rs)) {

    if($index == 0) {
        echo '<div id="container">';
        $position = "";
    }
    elseif($index == 1) {
        $position = "";
    }
    elseif($index == 2) {
        $position = "";
    }
    elseif($index == 3) {
        $position = "";
    }


    echo '<li class="one_quarter'.$position.'">';
    echo '<article class="clear">';
    echo '<figure class="post-image">';
    echo '<a href="'.$getRowAssoc['pdf'].'">';    
    echo '<img src="'.$getRowAssoc['pic'].'" alt="" style="border:1px solid orange"" height="585" width="585"></img></a>';
    echo '<header>';
    echo '<h2 class="auto-style3"><a href="'.$getRowAssoc['pdf'].'">'.$getRowAssoc['name'].'</a></h2>';
    echo '<div class="blog-post-meta">';
    echo '<ul>';
    echo '<li class="blog-post-cats">Catagories:<a href="'.$getRowAssoc['catagorylink'].'">'.$getRowAssoc['catagory'].'</a>';
    echo '</li>';
    echo '</ul>';
    echo '</div>';
    echo '</header>';
    echo '<p>'.$getRowAssoc['description'].'</p>';
    echo '<p>*See Specification Sheet for Details.</p>';
    echo '<footer class="read-more"><a href="'.$getRowAssoc['pdf'].'">Download Specification Sheet &raquo;</a>';
    echo '</footer>';
    echo '</article>';
    echo '</li>';    

    $index++;
    if($index == 4) {
        echo '</div>';
        $index = 0;
    }
}
?>