title: PHP MyAdmin Inserting data twice
body: <p>I am adding afew tables to a current database that will drive an online menu.</p>
  
  <p>So far I have created the 'Menu Categories' table. Below is the table structure.</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `menu_categories` (
    `id` int(2) NOT NULL AUTO_INCREMENT,
    `cat_id` varchar(6) NOT NULL,
    `cat_name` text NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `cat_id` (`cat_id`)
  )
  </code></pre>
  
  <p>I have yet to write the PHO scripting but just wanted to insert a few dummy categories for testing, but when I insert a category and then browse the table the data has been entered twice, so i get two of each category.</p>
  
  <p>I have looked around and cannot for the life of me figure out why, is this just PHP MyAdmin?</p>
  
  <p>Below are some print screen of inserting data and the end result:</p>
  
  <p><strong>Inputting the dummy data</strong></p>
  
  <p><img src="https://i.stack.imgur.com/rtM2N.png" alt="Inputting the dummy data"></p>
  
  <p><strong>The sql query for inserting dummy data</strong></p>
  
  <p><img src="https://i.stack.imgur.com/3b4Y8.png" alt="The sql query for inserting dummy data"></p>
  
  <p><strong>Preview of table with duplicate entries</strong></p>
  
  <p><img src="https://i.stack.imgur.com/Txoh7.png" alt="Preview of table with duplicate entries"></p>
  
  <p>Any idea what is going on here?</p>
  
  <p>Thanks</p>
  
  <p>*edit: I forgot to add that I tried setting the 'cat_id' to unique. Then when I ran the insert command, I then received an error about inserting duplicate data</p>