title: Category in PHP/MYSQL?
body: <p>I try to create a menu system and within that menu show whatever there is in MySQL based on one column!</p>
  
  <h3>Example</h3>
  
  <p>Currently, I can add products from my admin panel and it will be added into MySQL database. When I add a product, I can give this product a brand name i.e. diesel, levi, etc.</p>
  
  <h3>Question 1</h3>
  
  <p>Now I know how to show the contents of the database in MySQL in a PHP file by using <code>SELECT brand FROM products ...</code>, but this will show all the duplicated brands in my menu (e.g. 3 levi's, 6 diesels) and it will show them like:</p>
  
  <blockquote>
    <p>levi<br>
    levi<br>
    levi<br>
    Diesel<br>
    Diesel<br>
    Diesel<br>
    Diesel</p>
  </blockquote>
  
  <p>But I only 1 need of each. How can I do that?</p>
  
  <h3>Question number 2</h3>
  
  <p>How can I link the diesel category only to products that have that brand? For instance, if someone clicks on the diesel category, php will only show products that have the diesel brand.</p>