title: MySQL is duplicating results
body: <p>Running a Select and it is duplicating the results 3 time for the 2nd WHERE clause, can someone help me out. I cannot find anything online to see if I can figure it out myself.</p>
  
  <pre><code>        $searchCat = $mysqli-&gt;query("
          SELECT 
              business.name, business.street
          FROM 
              business, category
          WHERE 
              (category.category_id = business.category_id AND category.name = '$searchTerm') OR
              (business.search_term_8 = '$searchTerm')
      ")
  </code></pre>
  
  <p>It goes away when I use GROUP BY, if that is how it works great but I am concerned that it is not suppose to do that.</p>
  
  <p>I definetly do not have any duplicate records in the table at this time.</p>
  
  <p>Out put looks like this:</p>
  
  <ul>
  <li>City Grill, 2841 E Sprague st - 5</li>
  <li>Chappy's Restaurant, 13 Main St - 5</li>
  <li>Chappy's Restaurant, 13 Main St - 5</li>
  <li>Chappy's Restaurant, 13 Main St - 5</li>
  <li>Howie's Pizza Bar, 552 Ace St - 5</li>
  <li>Howie's Pizza Bar, 552 Ace St - 5</li>
  <li>Howie's Pizza Bar, 552 Ace St - 5</li>
  <li>House Inc, 123 - 5</li>
  </ul>
  
  <p>Tables:</p>
  
  <p><em>category</em></p>
  
  <ul>
  <li>category_id :: <strong>1, 2, 3</strong></li>
  <li>name :: <strong>bar, restaurant, spa</strong></li>
  </ul>
  
  <p><em>business</em></p>
  
  <ul>
  <li>business_id :: <strong>1, 2, 3, 4</strong>  </li>
  <li>business.name :: <strong>City Grill, Chappy's, Howie's; House Inc</strong></li>
  <li>business.street :: <strong>street info</strong></li>
  <li>category_id :: <strong>1, ,1,1</strong></li>
  <li>search_term_1 :: <strong>empty</strong></li>
  <li>---thru <strong>all are empty</strong></li>
  <li>search_term_8 :: <strong>bar</strong></li>
  </ul>
  
  <p>Searching for "bar"</p>