title: Table cannot be created
body: <p>I have written this code, but still table can not be created in database. And just output is:</p>
  
  <blockquote>
    <p>"database created.... Sorry Table Not Created".</p>
  </blockquote>
  
  <pre><code>&lt;?php                                   
      include 'connection.php';
      //Creating database
      $creatingdatabase = "CREATE DATABASE IF NOT EXISTS quest";
      $query1 = mysqli_query($con, $creatingdatabase);
      if($query1){ 
  
          echo "database created....";
          //creating tables
          $creatingtable = "CREATE TABLE quiz (
                          id INT(6) AUTO_INCREMENT PRIMARY KEY,
                          questions VARCHAR(255) NOT NULL,
                          optiona VARCHAR(255) NOT NULL,
                          optionb VARCHAR(255) NOT NULL,
                          optionc VARCHAR(255) NOT NULL,
                          optiond VARCHAR(255) NOT NULL, 
                          answer VARCHAR(50) NOT NULL
                                                  )";
          $query2 = mysqli_query($con, $creatingtable);
          if($query2){echo "table created...";}
          else { echo "sorry... table not created"; }
  
      }
      else { echo "database can not be created"; }
  ?&gt;
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/CwJ2w.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CwJ2w.jpg" alt="This is the output as seen in the browser."></a></p>